From: | "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net> |
---|---|
To: | Dan Gorman <dgorman(at)hi5(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Postgres fsync off (not needed) with NetApp |
Date: | 2006-06-14 21:53:24 |
Message-ID: | 20060614175324.a3f9ffb4.darcy@druid.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Lewis | 2006-06-14 21:54:45 | Re: Postgres fsync off (not needed) with NetApp |
Previous Message | Dan Gorman | 2006-06-14 21:48:04 | Postgres fsync off (not needed) with NetApp |