From: Greg Smith <gsmith@gregsmith.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Mark Wong <markwkm@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: file system and raid performance
Date: Sat, 16 Aug 2008 00:53:20 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0808160032250.4135@westnet.com> (raw)
In-Reply-To: <200808151922.m7FJMxJ21964@momjian.us>
References: <200808151922.m7FJMxJ21964@momjian.us>
On Fri, 15 Aug 2008, Bruce Momjian wrote:
> 'data=writeback' is the recommended mount method for that file system,
> though I see that is not mentioned in our official documentation.
While writeback has good performance characteristics, I don't know that
I'd go so far as to support making that an official recommendation. The
integrity guarantees of that journaling mode are pretty weak. Sure the
database itself should be fine; it's got the WAL as a backup if the
filesytem loses some recently written bits. But I'd hate to see somebody
switch to that mount option on this project's recommendation only to find
some other files got corrupted on a power loss because of writeback's
limited journalling. ext3 has plenty of problem already without picking
its least safe mode, and recommending writeback would need a carefully
written warning to that effect.
--
* 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, bruce@momjian.us, markwkm@gmail.com
Subject: Re: file system and raid performance
In-Reply-To: <Pine.GSO.4.64.0808160032250.4135@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