Re: Linux Filesystems again - Ubuntu this time

Поиск
Список
Период
Сортировка
От Whit Armstrong
Тема Re: Linux Filesystems again - Ubuntu this time
Дата
Msg-id AANLkTi=5KDvSNAjXNOB378oFP-EYtfzMbd=vNoRY6Fsa@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Linux Filesystems again - Ubuntu this time  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: Linux Filesystems again - Ubuntu this time  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-performance
Thanks.

But there is no such risk to turning off write barriers?

I'm only specifying noatime for xfs at the moment.

Did you get a substantial performace boost from disabling write
barriers?  like 10x or more like 2x?

Thanks,
Whit



On Tue, Jul 27, 2010 at 1:19 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
> "Kevin Grittner" <Kevin.Grittner@wicourts.gov> wrote:
>
>> Basically, you should never use fsync unless you are OK with
>> losing everything in the database server if you have an OS or
>> hardware failure.
>
> s/use/disable/
>
> -Kevin
>

В списке pgsql-performance по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: What is the best way to optimize the query.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: potential performance gain by query planner optimization