> 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
