From: D'Arcy J.M. Cain <darcy@druid.net>
To: Dan Gorman <dgorman@hi5.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres fsync off (not needed) with NetApp
Date: Wed, 14 Jun 2006 17:53:24 -0400
Message-ID: <20060614175324.a3f9ffb4.darcy@druid.net> (raw)
In-Reply-To: <9A377C54-361D-4F01-BF7A-7632FBA3453C@hi5.com>
References: <9A377C54-361D-4F01-BF7A-7632FBA3453C@hi5.com>
On Wed, 14 Jun 2006 14:48:04 -0700
Dan Gorman <dgorman@hi5.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@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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: darcy@druid.net, dgorman@hi5.com
Subject: Re: Postgres fsync off (not needed) with NetApp
In-Reply-To: <20060614175324.a3f9ffb4.darcy@druid.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox