Re: Filesystem options for storing pg_data - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Filesystem options for storing pg_data
Date
Msg-id 1114013880.20921.576.camel@state.g2switchworks.com
Whole thread Raw
In response to Filesystem options for storing pg_data  (Joe Maldonado <jmaldonado@webehosting.biz>)
Responses Re: Filesystem options for storing pg_data  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
On Wed, 2005-04-20 at 11:07, Joe Maldonado wrote:
> Hello all,
>
> I am in a position where I'm torn between using ext2 vs ext3 to keep the
> pg_data, pg_xlog, and pg_clog contents.
>
> The main concern is that switching to ext2 will not respond well to an
> improper shutdown, power loss.
>
> My question is what is the prefered filesystem to keep this data to be
> able to optimize performance and still have some fault tolerance.

Generally XFS and JFS are considered superior to ext2/3.

ext3, in my experience, isn't much slower than ext2.  Plus the decreased
time required to bring up a server after a power outage is worth
something too.

Having used ext3 quite a bit, I'd say it's fairly stable and reliable,
but I have seen references here to know, possibly unfixable bugs.

I've used XFS a few years back, and there was no great gain for what we
were doing at the time, as we were CPU, not I/O bound.

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: What means Postgres?
Next
From: tony
Date:
Subject: Re: What means Postgres?