> 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.
In response to
pgsql-performance by date
|Next:||From: Alex Turner||Date: 2006-12-30 03:22:35|
|Subject: Re: High update activity, PostgreSQL vs BigDBMS|
|Previous:||From: Russell Smith||Date: 2006-12-29 21:25:12|
|Subject: Re: Backup/Restore too slow|