Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group