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

From Chris Browne
Subject Re: XFS filessystem for Datawarehousing -2
Date
Msg-id 60hd0tilgr.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to FW: XFS filessystem for Datawarehousing -2  ("Milen Kulev" <makulev@gmx.net>)
Responses Re: XFS filessystem for Datawarehousing -2
List pgsql-performance
denisl@enterprisedb.com ("Denis Lussier") writes:
> I have no personal experience with XFS, but, I've seen numerous
> internal edb-postgres test results that show that of all file
> systems... OCFS 2.0 seems to be quite good for PG update intensive
> apps (especially on 64 bit machines).

I have been curious about OCFS for some time; it sounded like a case
where there could possibly be some useful semantic changes to
filesystem functionality, notably that:

 - atime is pretty irrelevant;
 - it might try to work with pretty fixed block sizes (8K, perhaps?)
   rather than try to be efficient at handling tiny files

It sounds like it ought to be able to be a good fit.

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?
--
select 'cbbrowne' || '@' || 'cbbrowne.com';
http://www.ntlug.org/~cbbrowne/oses.html
"There  isn't  any  reason  why  Linux  can't  be  implemented  as  an
enterprise  computing solution.   Find  out what  you've been  missing
while you've been rebooting Windows NT." - Infoworld

pgsql-performance by date:

Previous
From: Ian Westmacott
Date:
Subject: Re:
Next
From: "Luke Lonergan"
Date:
Subject: Re: XFS filessystem for Datawarehousing