Re: Postgres fsync off (not needed) with NetApp

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