Re: ext3 filesystem / linux 7.3 - Mailing list pgsql-performance

From Jeffrey D. Brower
Subject Re: ext3 filesystem / linux 7.3
Date
Msg-id 093201c2f88f$45e60730$0b02a8c0@pointhere.net
Whole thread Raw
In response to Re: ext3 filesystem / linux 7.3  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: ext3 filesystem / linux 7.3
List pgsql-performance
OK so am I hearing:

XFS is the fastest (but is it the safest?) but does not come on Linux.

Ext2 does less work than Ext3 so is fastest among what DOES come with
Linux - but if you have a crash that fsck can't fix you're hosed.

Ext3 is quite a bit slower if set to be real safe, a wee bit slower if run
with standard options which makes it more crash-safe, and much slower if the
mount flags are set to metadata journaling but that is much safer as a file
system because the metadata journaling is complementary to the PG
transactioning.

To determine which you want you must choose which one feels to you like the
right balance of speed and the setup work you are willing to perform and
maintain.

Do I have it right?

   Jeff


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgresql performance on Solaris
Next
From: "Keith Bottner"
Date:
Subject: Re: ext3 filesystem / linux 7.3