Re: WAL sync behaviour - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: WAL sync behaviour
Date
Msg-id 1131637958.3554.75.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: WAL sync behaviour  (Michael Stone <mstone+postgres@mathom.us>)
Responses Re: WAL sync behaviour
Re: WAL sync behaviour
List pgsql-performance
On Thu, 2005-11-10 at 08:43, Michael Stone wrote:
> On Thu, Nov 10, 2005 at 03:25:35PM +0100, Steinar H. Gunderson wrote:
> >Ah, yes, I forgot -- it's ext3. We're considering simply moving the WAL onto
> >a separate partition (with data=writeback and noatime) if that can help us
> >any.
>
> There's no reason to use a journaled filesystem for the wal. Use ext2 in
> preference to ext3.

Not from what I understood.  Ext2 can't guarantee that your data will
even be there in any form after a crash.  I believe only metadata
journaling is needed though.

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Some help on buffers and other performance tricks
Next
From: Michael Stone
Date:
Subject: Re: WAL sync behaviour