Re: High update activity, PostgreSQL vs BigDBMS

[Alvaro Herrera <alvherre(at)commandprompt(dot)com>]

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.