Re: Sanity check requested

Поиск
Список
Период
Сортировка
От Vincent van Leeuwen
Тема Re: Sanity check requested
Дата
Msg-id 20030718160042.GV21071@md2.mediadesign.nl
обсуждение исходный текст
Ответ на Re: Sanity check requested  ("Nick Fankhauser" <nickf@ontko.com>)
Ответы Re: Sanity check requested
Список pgsql-performance
On 2003-07-17 10:41:35 -0500, Nick Fankhauser wrote:
> I'm using ext2. For now, I'll leave this and the OS version alone. If I
>

I'd upgrade to a journaling filesystem as soon as possible for reliability.
Testing in our own environment has shown that PostgreSQL performs best on ext3
(yes, better than XFS, JFS or ReiserFS) with a linux 2.4.21 kernel. Be sure to
mount noatime and to create the ext3 partition with the correct stripe size of
your RAID array using the '-R stride=foo' option (see man mke2fs).

Vincent van Leeuwen
Media Design - http://www.mediadesign.nl/

В списке pgsql-performance по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: Sanity check requested
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Yet another slow join query..