Just pick up a SCSI drive and a consumer ATA drive. Feel their weight. You don't have to look inside to tell the difference. Alex On 11/16/05, David Boreham <david_list@xxxxxxxxxxx> wrote: > > > I suggest you read this on the difference between enterprise/SCSI and > desktop/IDE drives: > > http://www.seagate.com/content/docs/pdf/whitepaper/D2c_More_than_Interface_ATA_vs_SCSI_042003.pdf > > > This is exactly the kind of vendor propaganda I was talking about > and it proves my point quite well : that there's nothing specific relating > to reliability that is different between SCSI and SATA drives cited in that > paper. > It does have a bunch of FUD such as 'oh yeah we do a lot more > drive characterization during manufacturing'. > > > > ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match