Re: Hardware needed for 15,000,000 record DB? - Mailing list pgsql-admin

From Jeremy Buchmann
Subject Re: Hardware needed for 15,000,000 record DB?
Date
Msg-id 3CC59868.3020502@wellsgaming.com
Whole thread Raw
In response to Re: Hardware needed for 15,000,000 record DB?  (Curt Sampson <cjs@cynic.net>)
Responses Re: Hardware needed for 15,000,000 record DB?
List pgsql-admin
Curt Sampson wrote:
> On Mon, 22 Apr 2002, Jeremy Buchmann wrote:
>
>>You minimize the amount of time the I/O takes by using fast
>>storage devices.
>>This means SCSI.
>
>
> Not necessarially. More disk arms is also a big help, so much so
> that I would take two IDE drives (assuming that they're fast modern
> ones) over one SCSI drive any day.

SCSI also has several other advantages...it doesn't suck up all your
CPU time when there's a lot of disk activity, and it supports
command queueing.  IDE was designed to be cheap, SCSI was designed to
be good.  I've used both and from my experience, SCSI is The Way.

--Jeremy


pgsql-admin by date:

Previous
From: "youngsu"
Date:
Subject: How can I ld_library path set for lpq++ with FreeBSD ?
Next
From: David Gilbert
Date:
Subject: Re: Hardware needed for 15,000,000 record DB?