Re: Some Performance Advice Needed

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: Alex <alex(at)meerkatsoft(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Some Performance Advice Needed
Date: 2004-12-23 14:44:31
Message-ID: 27CB29DA-54F1-11D9-9712-000D9366F0C4@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message William Yu 2004-12-23 20:49:09 Re: Some Performance Advice Needed
Previous Message Alex 2004-12-23 14:27:15 Some Performance Advice Needed