Re: no universally correct setting for fsync

Поиск
Список
Период
Сортировка
От Bernd Helmle
Тема Re: no universally correct setting for fsync
Дата
Msg-id D9EB8B28CCC10C46B7DD3472@amenophis
обсуждение исходный текст
Ответ на Re: no universally correct setting for fsync  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

--On 7. Mai 2010 19:49:15 -0400 Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Bernd Helmle <mailings@oopsware.de> writes:
>> I've recently even started to wonder if the performance gain with
>> fsync=off  is still that large on modern hardware. While testing large
>> migration  procedures to a new version some time ago (on an admitedly
>> fast storage) i  forgot here and then to turn it off, without a
>> significant degradation in  performance.
>
> That says to me either that you're using a battery-backed write cache,
> or your fsyncs don't really work (no write barriers or something like
> that).
>

Well, yes, BBU present and proven storage. Maybe i'm wrong, but it seems 
battery backed write caches aren't that seldom even in low end systems 
nowadays.

-- 
Thanks
Bernd


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: no universally correct setting for fsync
Следующее
От: hgonzalez@gmail.com
Дата:
Сообщение: Re: [GENERAL] psql weird behaviour with charset encodings