Anjan, > Question - Are 73GB drives supposed to give better performance because > of higher number of platters?
Not for your situation, no. Your issue is random seek times for multiple simultaneous seek requests and batched checkpoint updates. Things that help with this are: More spindles Better controllers, both RAID and individual disks Faster drives Particularly, I'd check out stuff like reports from Tom's Hardware for evaluating the real speed of drives and seek times. Often a really good 10000 RPM SCSI will beat a 15000RPM SCSI if the latter has poor onboard programming. -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match