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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings