Re: Postgres fsync off (not needed) with NetApp

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
Cc: Dan Gorman <dgorman(at)hi5(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres fsync off (not needed) with NetApp
Date: 2006-06-15 03:33:53
Message-ID: 873be7ay8u.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Mark Lewis <mark(dot)lewis(at)mir3(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2006-06-15 04:05:38 Test request for Stats collector performance improvement
Previous Message Tom Lane 2006-06-15 02:36:55 Re: Confirmation of bad query plan generated by 7.4