Re: One particular large database application

From: Curt Sampson <cjs(at)cynic(dot)net>
To: Francisco Reyes <lists(at)natserv(dot)com>
Cc: pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: One particular large database application
Date: 2002-04-22 23:08:16
Message-ID: Pine.NEB.4.43.0204230801470.4187-100000@angelic.cynic.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Loftis 2002-04-23 04:20:21 Re: One particular large database application
Previous Message Ian Harding 2002-04-22 22:36:21 Re: nested transactions