>> 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.
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2004-12-23 22:44:34|
|Subject: Re: Memory leak tsearch2 VACUUM FULL VERBOSE ANALYZE |
|Previous:||From: Joshua D. Drake||Date: 2004-12-23 21:27:12|
|Subject: Re: Some Performance Advice Needed|