Re: How to improve db performance with $7K? - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: How to improve db performance with $7K?
Date
Msg-id 20050419230836.GQ58835@decibel.org
Whole thread Raw
In response to Re: How to improve db performance with $7K?  (Matthew Nuzum <mattnuzum@gmail.com>)
List pgsql-performance
On Thu, Apr 14, 2005 at 10:51:46AM -0500, Matthew Nuzum wrote:
> So if you all were going to choose between two hard drives where:
> drive A has capacity C and spins at 15K rpms, and
> drive B has capacity 2 x C and spins at 10K rpms and
> all other features are the same, the price is the same and C is enough
> disk space which would you choose?
>
> I've noticed that on IDE drives, as the capacity increases the data
> density increases and there is a pereceived (I've not measured it)
> performance increase.
>
> Would the increased data density of the higher capacity drive be of
> greater benefit than the faster spindle speed of drive A?

The increased data density will help transfer speed off the platter, but
that's it. It won't help rotational latency.
--
Jim C. Nasby, Database Consultant               decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

pgsql-performance by date:

Previous
From: Mark Wong
Date:
Subject: Re: [HACKERS] PLM pulling from CVS nightly for testing in STP
Next
From: "Jim C. Nasby"
Date:
Subject: Re: How to improve db performance with $7K?