Re: Some Performance Advice Needed - Mailing list pgsql-performance

From Jeff
Subject Re: Some Performance Advice Needed
Date
Msg-id 27CB29DA-54F1-11D9-9712-000D9366F0C4@torgo.978.org
Whole thread Raw
In response to Some Performance Advice Needed  (Alex <alex@meerkatsoft.com>)
Responses Re: Some Performance Advice Needed
List pgsql-performance
On Dec 23, 2004, at 9:27 AM, Alex wrote:


> Running hdparm reported
> A) 920mb/s   (SCSI 10k)
> B) 270mb/s   (SCSI 10k)
> C) 1750mb/s  (IDE  7.2k)


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.

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/


pgsql-performance by date:

Previous
From: Alex
Date:
Subject: Some Performance Advice Needed
Next
From: William Yu
Date:
Subject: Re: Some Performance Advice Needed