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

Re: Some Performance Advice Needed

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, Alex <alex(at)meerkatsoft(dot)com>
Subject: Re: Some Performance Advice Needed
Date: 2004-12-27 13:46:28
Message-ID: B59DACCE-580D-11D9-830A-000D9366F0C4@torgo.978.org (view raw or flat)
Thread:
Lists: pgsql-performance
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 
archives.
Maybe we can get him to pipe up :)

--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/


In response to

pgsql-performance by date

Next:From: sarlav kumarDate: 2004-12-27 17:32:33
Subject: user defined data type problem while dumping?
Previous:From: Cosimo StrepponeDate: 2004-12-27 11:36:50
Subject: Re: Howto Increased performace ?

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