Re: Some Performance Advice Needed

From: William Yu <wyu(at)talisys(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Some Performance Advice Needed
Date: 2004-12-23 21:45:57
Message-ID: cqfecl$2bmm$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>> 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

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-12-23 22:44:34 Re: Memory leak tsearch2 VACUUM FULL VERBOSE ANALYZE
Previous Message Joshua D. Drake 2004-12-23 21:27:12 Re: Some Performance Advice Needed