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

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to