Re: Postgres fsync off (not needed) with NetApp

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/