"Shridhar Daithankar" <[EMAIL PROTECTED]> writes: >> - Would a RAID setup make the disk faster? Because top rarely shows the >> CPUs above 50%, I suspect maybe the disk is the bottleneck.
> Yes it is. You need to move WAL to a different disk. For an update-intensive setup, putting WAL on its own disk is definitely your biggest win. You might then find it rewarding to fool with the wal_sync_method and perhaps to bump up wal_buffers a little. A small number of people have had luck with putting a nonzero commit_delay but I have little faith in that. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings