Skip site navigation (1) Skip section navigation (2)

Re: SAN and full_page_writes

From: "Nikolas Everett" <nik9000(at)gmail(dot)com>
To: "Gregory Stark" <stark(at)enterprisedb(dot)com>
Cc: "Bruce Momjian" <bruce(at)momjian(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: SAN and full_page_writes
Date: 2008-09-08 15:17:41
Message-ID: d4e11e980809080817l4f29c647s2e4485451c5e62c1@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, Sep 8, 2008 at 10:59 AM, Gregory Stark <stark(at)enterprisedb(dot)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

In response to

pgsql-performance by date

Next:From: Matt SmileyDate: 2008-09-08 16:16:16
Subject: Re: inaccurate stats on large tables
Previous:From: Gregory StarkDate: 2008-09-08 14:59:03
Subject: Re: SAN and full_page_writes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group