| From: | Jeremy Buchmann <jeremy(at)wellsgaming(dot)com> |
|---|---|
| To: | Curt Sampson <cjs(at)cynic(dot)net> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Hardware needed for 15,000,000 record DB? |
| Date: | 2002-04-23 17:22:48 |
| Message-ID: | 3CC59868.3020502@wellsgaming.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Gilbert | 2002-04-23 17:44:40 | Re: Hardware needed for 15,000,000 record DB? |
| Previous Message | youngsu | 2002-04-23 11:38:01 | How can I ld_library path set for lpq++ with FreeBSD ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Gilbert | 2002-04-23 17:44:40 | Re: Hardware needed for 15,000,000 record DB? |
| Previous Message | P. Jourdan | 2002-04-23 17:13:13 | Re: Database creation problem |