Re: High update activity, PostgreSQL vs BigDBMS

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: High update activity, PostgreSQL vs BigDBMS
Дата
Msg-id 20061229220747.GB15429@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: High update activity, PostgreSQL vs BigDBMS  (Ron <rjpeace@earthlink.net>)
Ответы Re: High update activity, PostgreSQL vs BigDBMS  (Jeff Frost <jeff@frostconsultingllc.com>)
Re: High update activity, PostgreSQL vs BigDBMS  (Geoffrey <esoteric@3times25.net>)
Список pgsql-performance
Ron wrote:

> C= What file system are you using?  Unlike BigDBMS, pg does not have
> its own native one, so you have to choose the one that best suits
> your needs.  For update heavy applications involving lots of small
> updates jfs and XFS should both be seriously considered.

Actually it has been suggested that a combination of ext2 (for WAL) and
ext3 (for data, with data journalling disabled) is a good performer.
AFAIK you don't want the overhead of journalling for the WAL partition.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Предыдущее
От: Russell Smith
Дата:
Сообщение: Re: Backup/Restore too slow
Следующее
От: Jeff Frost
Дата:
Сообщение: Re: High update activity, PostgreSQL vs BigDBMS