Re: Postgres fsync off (not needed) with NetApp

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



That makes sense. Speaking of NetApp, we're using the 3050C with 4 FC shelfs. Any generic advice other than the NetApp (their NFS oracle tuning options)
that might be useful? (e.g. turning off snapshots)

Regards,
Dan Gorman

On Jun 14, 2006, at 10:14 PM, Jonah H. Harris wrote:

On 14 Jun 2006 23:33:53 -0400, Greg Stark <gsstark@xxxxxxx> 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@xxxxxxxxxxxxxxxx
Iselin, New Jersey 08830            | http://www.enterprisedb.com/




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux