Re: One particular large database application - Mailing list pgsql-general

From Curt Sampson
Subject Re: One particular large database application
Date
Msg-id Pine.NEB.4.43.0204230801470.4187-100000@angelic.cynic.net
Whole thread Raw
In response to Re: One particular large database application  (Francisco Reyes <lists@natserv.com>)
Responses Re: One particular large database application
List pgsql-general
On Mon, 22 Apr 2002, Francisco Reyes wrote:

> IDE's may have good thoughput, but their seek times can't compete with top
> of the line SCSI.

Dollar for dollar, IDE has far better performance. Even including the
cost of extra controllers (because you need one controller for each
drive), I can get four high-end IDE drives for the price of one SCSI
drive. There's no way any SCSI drive is going to do as many I/Os per
second as four good IDE drives.

As well, seek time isn't always important. For your log disk, for
example, you care more about high sequential write speed.

> Exactly.. since it won't be easy for you to find the best distributions
> then it may be worth getting better hardware. :-)

What makes you think it won't be easy, in my case?

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC


pgsql-general by date:

Previous
From: "Ian Harding"
Date:
Subject: Re: nested transactions
Next
From: Michael Loftis
Date:
Subject: Re: One particular large database application