> It's a quad opteron system. RAID controller is a 4 channel LSILogic > Megaraid > 320 connected to 10 15k 36.7G SCSI disks. The disks are configured in 5 > mirrored partitions. The pg_xlog is on one mirror and the data and indexes > are spread over the other 4 using tablespaces. These numbers from > pg_stat_user_tables are from about 2 hours earlier today on this one > table. > > > idx_scan 20578690 > idx_tup_fetch 35866104841 > n_tup_ins 1940081 > n_tup_upd 1604041 > n_tup_del 1880424
Is your raid controller configured to buffer your writes? How much RAM are you packing? Are you running 64 bit? Merlin ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
