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

From Mark Lewis
Subject Re: Postgres fsync off (not needed) with NetApp
Date
Msg-id 1150322085.31200.39.camel@archimedes
Whole thread Raw
In response to Postgres fsync off (not needed) with NetApp  (Dan Gorman <dgorman@hi5.com>)
Responses Re: Postgres fsync off (not needed) with NetApp  (Greg Stark <gsstark@mit.edu>)
List 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 by date:

Previous
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: Postgres fsync off (not needed) with NetApp
Next
From: Bruce Momjian
Date:
Subject: Re: Effects of cascading references in foreign keys