On Jul 13, 2005, at 2:54 PM, Dan Harris wrote:
4 x 2.2GHz Opterons 12 GB of RAM 4x10k 73GB Ultra320 SCSI drives in RAID 0+1 1GB hardware cache memory on the RAID controller
if it is taking that long to update about 25% of your table, then you must be I/O bound. check I/o while you're running a big query.
also, what RAID controller are you running? be sure you have the latest BIOS and drivers for it.
on a pair of dual opterons, I can do large operations on tables with 100 million rows much faster than you seem to be able. I have MegaRAID 320-2x controllers with 15kRPM drives.
Vivek Khera, Ph.D. +1-301-869-4449 x806
Description: S/MIME cryptographic signature