IDE disks lie about write completion (This can be disabled on some drives) whereas SCSI drives wait for the data to actually be written before they report success. It is quite
easy to corrupt a PG (Or most any db really) on an IDE drive. Check the archives for more info.
Do we have any real info on this? Specifically which drives? Is SATA the same way? What about SATA-II?
I am not saying it isn't true (I know it is) but this is a blanket statement that may or may not be
true with newer tech.
From my experience with SATA controllers, write caching is controlled via the BIOS.
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster