Re: limiting performance impact of wal archiving. - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: limiting performance impact of wal archiving.
Date
Msg-id dcc563d10911100910y9229f50pdc150f3ea41ae9e8@mail.gmail.com
Whole thread Raw
In response to Re: limiting performance impact of wal archiving.  (Craig James <craig_james@emolecules.com>)
List pgsql-performance
On Tue, Nov 10, 2009 at 10:07 AM, Craig James
<craig_james@emolecules.com> wrote:
> On Tue, Nov 10, 2009 at 5:35 PM, Greg Smith <greg@2ndquadrant.com> wrote:
>>
>> Given the current quality of Linux code, I hesitate to use anything but
>> ext3
>> because I consider that just barely reliable enough even as the most
>> popular
>> filesystem by far.  JFS and XFS have some benefits to them, but none so
>> compelling to make up for how much less testing they get.  That said,
>> there
>> seem to be a fair number of people happily running high-performance
>> PostgreSQL instances on XFS.
>
> I thought the common wisdom was to use ext2 for the WAL, since the WAL is a
> journal system, and ext3 would essentially be journaling the journal.  Is
> that not true?

Yep, ext2 for pg_xlog is fine.

pgsql-performance by date:

Previous
From: Craig James
Date:
Subject: Re: limiting performance impact of wal archiving.
Next
From: Greg Smith
Date:
Subject: Re: limiting performance impact of wal archiving.