On Dec 10, 2005, at 6:37 PM, Benjamin Arai wrote:
For the most part the updates are simple one liners. I currently commit in large batch to increase performance but it still takes a while as stated above. From evaluating the computers performance during an update, the system is thrashing both memory and disk. I am currently using Postgresql 8.0.3.
Then buy faster disks. My current favorite is to use U320 15kRPM disks using a dual-chanel RAID controller with 1/2 the disks on one channel and 1/2 on the other and mirroring them across channels, then striping down the mirrors (ie, RAID10).
I use no fewer than 6 disks (RAID 10) for data and 2 for pg_log in a RAID1.
