Re: Postgres fsync off (not needed) with NetApp

["D'Arcy J.M. Cain" <darcy(at)druid(dot)net>]

On Wed, 14 Jun 2006 14:48:04 -0700
Dan Gorman <dgorman(at)hi5(dot)com> wrote:
> 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?

I wouldn't.  Remember, you still have to get the data to the NetApp.
You don't want things sitting in the computer's buffers when it's power
goes down.

-- 
D'Arcy J.M. Cain <darcy(at)druid(dot)net>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.