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

From Jonah H. Harris
Subject Re: Postgres fsync off (not needed) with NetApp
Date
Msg-id 36e682920606142214i6a6532f3k1a895a784f7b16dc@mail.gmail.com
Whole thread Raw
In response to Re: Postgres fsync off (not needed) with NetApp  (Greg Stark <gsstark@mit.edu>)
Responses Re: Postgres fsync off (not needed) with NetApp  (Dan Gorman <dgorman@hi5.com>)
Re: Postgres fsync off (not needed) with NetApp  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-performance
On 14 Jun 2006 23:33:53 -0400, Greg Stark <gsstark@mit.edu> wrote:
> In fact the benefit of the NVRAM is precisely that it makes sure you *don't*
> have any reason to turn fsync off. It should make the fsync essentially free.

Having run PostgreSQL on a NetApp with input from NetApp, this is
correct.  fsync should be turned on, but you will not incur the *real*
direct-to-disk cost of the sync, it will be direct-to-NVRAM.

--
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation            | fax: 732.331.1301
33 Wood Ave S, 2nd Floor            | jharris@enterprisedb.com
Iselin, New Jersey 08830            | http://www.enterprisedb.com/

pgsql-performance by date:

Previous
From: Zoltan Boszormenyi
Date:
Subject: Re: Precomputed constants?
Next
From: Dan Gorman
Date:
Subject: Re: Postgres fsync off (not needed) with NetApp