Re: XFS filessystem for Datawarehousing -2

Поиск
Список
Период
Сортировка
От Chris Browne
Тема Re: XFS filessystem for Datawarehousing -2
Дата
Msg-id 60hd0tilgr.fsf@dba2.int.libertyrms.com
обсуждение исходный текст
Ответ на FW: XFS filessystem for Datawarehousing -2  ("Milen Kulev" <makulev@gmx.net>)
Ответы Re: XFS filessystem for Datawarehousing -2  ("Denis Lussier" <denisl@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: Ian Westmacott
Дата:
Сообщение: Re:
Следующее
От: "Luke Lonergan"
Дата:
Сообщение: Re: XFS filessystem for Datawarehousing