Re: Need help with 8.4 Performance Testing

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Need help with 8.4 Performance Testing
Date: 2008-12-09 17:35:16
Message-ID: alpine.DEB.1.10.0812091732130.4666@aragorn.flymine.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 9 Dec 2008, Scott Marlowe wrote:
> I wonder how many hard drives it would take to be CPU bound on random
> access patterns? About 40 to 60? And probably 15k / SAS drives to
> boot. Cause that's what we're looking at in the next few years where
> I work.

There's a problem with that thinking. That is, in order to exercise many
spindles, you will need to have just as many (if not more) concurrent
requests. And if you have many concurrent requests, then you can spread
them over multiple CPUs. So it's more a case of "How many hard drives PER
CPU". It also becomes a matter of whether Postgres can scale that well.

Matthew

--
Those who do not understand Unix are condemned to reinvent it, poorly.
-- Henry Spencer

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-12-09 17:46:37 Re: Need help with 8.4 Performance Testing
Previous Message Scott Carey 2008-12-09 17:28:02 Re: Need help with 8.4 Performance Testing