X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6CB4A9FA5C8 for ; Wed, 14 Jun 2006 18:53:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 76526-09 for ; Wed, 14 Jun 2006 18:53:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from druid.net (druid.net [66.96.28.249]) by postgresql.org (Postfix) with ESMTP id 786609FA3D7 for ; Wed, 14 Jun 2006 18:53:25 -0300 (ADT) Received: from dilbert (H245.C18.B96.tor.eicat.ca [66.96.18.245]) by druid.net (Postfix) with SMTP id B5958B4B3; Wed, 14 Jun 2006 17:53:25 -0400 (EDT) Date: Wed, 14 Jun 2006 17:53:24 -0400 From: "D'Arcy J.M. Cain" To: Dan Gorman Cc: pgsql-performance@postgresql.org Subject: Re: Postgres fsync off (not needed) with NetApp Message-Id: <20060614175324.a3f9ffb4.darcy@druid.net> In-Reply-To: <9A377C54-361D-4F01-BF7A-7632FBA3453C@hi5.com> References: <9A377C54-361D-4F01-BF7A-7632FBA3453C@hi5.com> X-Mailer: Sylpheed version 2.2.4 (GTK+ 2.8.18; i386--netbsdelf) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/279 X-Sequence-Number: 19636 On Wed, 14 Jun 2006 14:48:04 -0700 Dan Gorman 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 | 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.