On Wed, 14 Jun 2006 14:48:04 -0700 Dan Gorman <[EMAIL PROTECTED]> 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@druid.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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster