On Dec 23, 2004, at 4:27 PM, Joshua D. Drake wrote:
>> 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.
Scott Marlowe did some tests a while ago on it. They are likely in the
Maybe we can get him to pipe up :)
Jeff Trout <jeff(at)jefftrout(dot)com>
In response to
pgsql-performance by date
|Next:||From: sarlav kumar||Date: 2004-12-27 17:32:33|
|Subject: user defined data type problem while dumping?|
|Previous:||From: Cosimo Streppone||Date: 2004-12-27 11:36:50|
|Subject: Re: Howto Increased performace ?|