Re: Postgres fsync off (not needed) with NetApp

Поиск
Список
Период
Сортировка
От Mark Lewis
Тема Re: Postgres fsync off (not needed) with NetApp
Дата
Msg-id 1150322085.31200.39.camel@archimedes
обсуждение исходный текст
Ответ на Postgres fsync off (not needed) with NetApp  (Dan Gorman <dgorman@hi5.com>)
Ответы Re: Postgres fsync off (not needed) with NetApp  (Greg Stark <gsstark@mit.edu>)
Список pgsql-performance
No.  You need fsync on in order to force the data to get TO the NetApp
at the right time.  With fsync off, the data gets cached in the
operating system.

-- Mark Lewis

On Wed, 2006-06-14 at 14:48 -0700, Dan Gorman wrote:
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

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

Предыдущее
От: "D'Arcy J.M. Cain"
Дата:
Сообщение: Re: Postgres fsync off (not needed) with NetApp
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Effects of cascading references in foreign keys