| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matt Smiley | 2008-09-08 16:16:16 | Re: inaccurate stats on large tables |
| Previous Message | Gregory Stark | 2008-09-08 14:59:03 | Re: SAN and full_page_writes |