From: Greg Smith <gsmith@gregsmith.com>
To: Franck Routier <franck.routier@axege.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: 12 disks raid setup
Date: Sat, 1 Mar 2008 23:17:18 -0500 (EST)
Message-ID: <Pine.GSO.4.64.0803012306050.10345@westnet.com> (raw)
In-Reply-To: <1204367277.9116.16.camel@franck-gusty>
References: <1204285894.11773.33.camel@franck-gusty>
<dcc563d10802290613v482f52dr43ea95b52886de31@mail.gmail.com>
<1204296705.11773.51.camel@franck-gusty>
<Pine.GSO.4.64.0802291019570.28452@westnet.com>
<47C8A6D9.1050502@Sheeky.Biz>
<Pine.GSO.4.64.0802292347250.145@westnet.com>
<1204367277.9116.16.camel@franck-gusty>
On Sat, 1 Mar 2008, Franck Routier wrote:
> Well, am I just wrong, or the file system might also heavily rely on
> cache, especially as I use XFS ? So anyway Postgresql has no way to know
> if the data is really on the disk, and in case of a brutal outage, the
> system may definitely lose data, wether there is another level of
> caching (Raid controller) or not...
After PostgreSQL writes to the WAL, it calls fsync. If your filesystem
doesn't then force a real write to disk at that point and clear whatever
cache it might have, it's broken and unsuitable for database use. XFS is
smart enough to understand that.
The only thing people typically run into that will hear fsync and lie
about the data actually being written to disk are a) caching controllers
with the write cache turned on and b) cheap hard drives. In case (a),
having a battery backup for the cache is sufficient to survive most
classes of outage without damage--if the system is without power for
longer than the battery lasts you're in trouble, otherwise is shouldn't be
a problem. In case (b), you have to turn the disk cache off to get
reliable database operation.
I've put all the interesting trivia on this topic I've ever come across at
http://www.westnet.com/~gsmith/content/postgresql/TuningPGWAL.htm if
you're looking for some really exciting reading.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
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: gsmith@gregsmith.com, franck.routier@axege.com
Subject: Re: 12 disks raid setup
In-Reply-To: <Pine.GSO.4.64.0803012306050.10345@westnet.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