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

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

pgsql-performance by date

Next:From: William YuDate: 2004-12-23 20:49:09
Subject: Re: Some Performance Advice Needed
Previous:From: AlexDate: 2004-12-23 14:27:15
Subject: Some Performance Advice Needed

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