Postgres Pro
Downloads
Home   >   mailing lists

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

From Dan Gorman
Subject Postgres fsync off (not needed) with NetApp
Date
Msg-id 9A377C54-361D-4F01-BF7A-7632FBA3453C@hi5.com
Whole thread Raw
Responses Re: Postgres fsync off (not needed) with NetApp  ("D'Arcy J.M. Cain" <darcy@druid.net>)
Re: Postgres fsync off (not needed) with NetApp  (Mark Lewis <mark.lewis@mir3.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Solaris shared_buffers anomaly?
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: Postgres fsync off (not needed) with NetApp