Re: XFS filessystem for Datawarehousing -2

Поиск
Список
Период
Сортировка
От Denis Lussier
Тема Re: XFS filessystem for Datawarehousing -2
Дата
Msg-id 5f820f750608041313v542640c5q5634f91263d7e915@mail.gmail.com
обсуждение исходный текст
Ответ на Re: XFS filessystem for Datawarehousing -2  (Chris Browne <cbbrowne@acm.org>)
Список 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 по дате отправления:

Предыдущее
От: "Mikael Carneholm"
Дата:
Сообщение: Re: RAID stripe size question
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: XFS filessystem for Datawarehousing