Re: Postgres fsync off (not needed) with NetApp - Mailing list pgsql-performance

From Greg Stark
Subject Re: Postgres fsync off (not needed) with NetApp
Date
Msg-id 873be7ay8u.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Postgres fsync off (not needed) with NetApp  (Mark Lewis <mark.lewis@mir3.com>)
Responses Re: Postgres fsync off (not needed) with NetApp
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Confirmation of bad query plan generated by 7.4
Next
From: Zoltan Boszormenyi
Date:
Subject: Re: Precomputed constants?