From: Gregory Stark <stark@enterprisedb.com>
To: Nikolas Everett <nik9000@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: SAN and full_page_writes
Date: Mon, 08 Sep 2008 15:59:03 +0100
Message-ID: <873aka4rbc.fsf@oxford.xeocode.com> (raw)
In-Reply-To: <d4e11e980809080748k6f647b6cue9d202f8feb9abca@mail.gmail.com>
References: <d4e11e980809050724m5f0e8971n3909c26026fda47b@mail.gmail.com>
<200809061946.m86JkeS01341@momjian.us>
<d4e11e980809080702i629187bbqab5dd70581ee8057@mail.gmail.com>
<87myii4t9o.fsf@oxford.xeocode.com>
<d4e11e980809080748k6f647b6cue9d202f8feb9abca@mail.gmail.com>
"Nikolas Everett" <nik9000@gmail.com> writes:
> Sounds kind of scary. I think postgres forces the underlying OS and file
> system to do that stuff (sans the mutli-host magic) using fsync. Is that
> right?
Yes, so you have to make sure that your filesystem really does support fsync
properly. I think most NFS implementations do that.
I was more concerned with:
Network Appliance supports a number of NFS client implementations for use
with databases. These clients provide write atomicity to at least 4 KB,
and support synchronous writes when requested by the database. Typically,
atomicity is guaranteed only to one virtual memory page, which may be as
small as 4 KB. However, if the NFS client supports a direct I/O mode that
completely bypasses the cache, then atomicity is guaranteed to the size
specified by the “wsize” mount option, typically 32 KB.
The failure of some NFS clients to assure write atomicity to a full
database block means that the soft atomicity requirement is not always
met. Some failures of the host system may result in a fractured database
block on disk. In practice such failures are rare. When they happen no
data is lost, but media recovery of the affected database block may be
required
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!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: stark@enterprisedb.com, nik9000@gmail.com, bruce@momjian.us
Subject: Re: SAN and full_page_writes
In-Reply-To: <873aka4rbc.fsf@oxford.xeocode.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox