Postgres fsync off (not needed) with NetApp

Поиск
Список
Период
Сортировка
От Dan Gorman
Тема Postgres fsync off (not needed) with NetApp
Дата
Msg-id 9A377C54-361D-4F01-BF7A-7632FBA3453C@hi5.com
обсуждение исходный текст
Ответы Re: Postgres fsync off (not needed) with NetApp
Re: Postgres fsync off (not needed) with NetApp
Список pgsql-performance
All,
   So I thought I'd pose this question:

If I have a pg database attached to a powervault (PV) with just an
off-the-shelf SCSI card I generally want fsync on to prevent data
corruption in case the PV should loose power.
However, if I have it attached to a NetApp that ensures data writes
to via the NVRAM can I safely turn fsync off to gain additional
performance?

Best Regards,
Dan Gorman



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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Solaris shared_buffers anomaly?
Следующее
От: "D'Arcy J.M. Cain"
Дата:
Сообщение: Re: Postgres fsync off (not needed) with NetApp