[EMAIL PROTECTED] wrote: > Next we'll upgrade the postgres hardware, and then I'll come > back to report if it's working better... sorry for the noise for now.
There have been some discussions about which hardware suits PostgreSQL's needs best under certain load-characteristics. We have experienced quite a write-performance burst just from switching from a RAID5-config to a RAID10 (mirroring&striping), even though we had been using some supposedly sufficiently powerful dedicated battery-backuped SCSI-RAID-adapters with lots of on-board cache. You can't beat simple, although it will cost disk-space. Anyway, you might want to search the archives for discussion on RAID-configurations. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster