Re: no universally correct setting for fsync

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: no universally correct setting for fsync
Дата
Msg-id 3860.1273276155@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: no universally correct setting for fsync  (Bernd Helmle <mailings@oopsware.de>)
Ответы Re: no universally correct setting for fsync  (Bernd Helmle <mailings@oopsware.de>)
Список pgsql-hackers
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).
        regards, tom lane


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

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