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