Re: XFS filessystem for Datawarehousing -2 - Mailing list pgsql-performance

From Denis Lussier
Subject Re: XFS filessystem for Datawarehousing -2
Date
Msg-id 5f820f750608041313v542640c5q5634f91263d7e915@mail.gmail.com
Whole thread Raw
In response to Re: XFS filessystem for Datawarehousing -2  (Chris Browne <cbbrowne@acm.org>)
List pgsql-performance

I agree that OCFS 2.0 is NOT a general purpose PG (or any other) solution.  My recollection is that OCFS gave about 15% performance improvements (same as setting some aggressive switches on ext3).   I assume OCFS has excellent crash safety with its default settings but we did not test this as of yet.  OCFS now ships as one of the optional FS's that ship with Suse.   That takes care of some of the FUD created by Oracle's disclaimer below.  

OCFS 2 is much more POSIX compliant than OCFS 1.  The BenchmarkSQL, DBT2, & Regression tests we ran on OCFS 2 all worked well.  The lack of full Posix compliance did cause some problems for configuring PITR.

--Denis       http://www.enterprisedb.com

On 8/3/06, Chris Browne <cbbrowne@acm.org > wrote:

Of course, with a big warning sticker of "what is required for Oracle
to work properly is implemented, anything more is not a guarantee" on
it, who's going to trust it?
--

pgsql-performance by date:

Previous
From: "Mikael Carneholm"
Date:
Subject: Re: RAID stripe size question
Next
From: "Jim C. Nasby"
Date:
Subject: Re: XFS filessystem for Datawarehousing