Postgres Pro
Downloads
Home   >   mailing lists

Re: SAN and full_page_writes - Mailing list pgsql-performance

From Nikolas Everett
Subject Re: SAN and full_page_writes
Date
Msg-id d4e11e980809080817l4f29c647s2e4485451c5e62c1@mail.gmail.com
Whole thread Raw
In response to Re: SAN and full_page_writes  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-performance
Tree view
On Mon, Sep 8, 2008 at 10:59 AM, Gregory Stark <stark@enterprisedb.com> wrote:

That "media recovery" it's referring to sounds like precisely our WAL full
page writes...


--
 Gregory Stark
 EnterpriseDB          http://www.enterprisedb.com
 Ask me about EnterpriseDB's PostGIS support!

That sounds right.

So the take home from this is that NetApp does its best to protect you from partial page writes but comes up short on untweaked NFS (see doc to tweak.)  Otherwise you are protected so long as your OS and file system implement fsync properly.

--Nik

pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: SAN and full_page_writes
Next
From: "Matt Smiley"
Date:
Subject: Re: inaccurate stats on large tables