Re: Postgres fsync off (not needed) with NetApp

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Postgres fsync off (not needed) with NetApp
Дата
Msg-id 873be7ay8u.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: Postgres fsync off (not needed) with NetApp  (Mark Lewis <mark.lewis@mir3.com>)
Ответы Re: Postgres fsync off (not needed) with NetApp  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Список pgsql-performance
Mark Lewis <mark.lewis@mir3.com> writes:

> On Wed, 2006-06-14 at 14:48 -0700, Dan Gorman wrote:
> >
> > 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?
>
> 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.

In fact the benefit of the NVRAM is precisely that it makes sure you *don't*
have any reason to turn fsync off. It should make the fsync essentially free.

--
greg

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Confirmation of bad query plan generated by 7.4
Следующее
От: Zoltan Boszormenyi
Дата:
Сообщение: Re: Precomputed constants?