Re: Need help with 8.4 Performance Testing - Mailing list pgsql-performance

From Robert Haas
Subject Re: Need help with 8.4 Performance Testing
Date
Msg-id 603c8f070812130522l7ccfe9ccx6118c4171f4187d5@mail.gmail.com
Whole thread Raw
In response to Re: Need help with 8.4 Performance Testing  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Need help with 8.4 Performance Testing  (david@lang.hm)
Re: Need help with 8.4 Performance Testing  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
On Tue, Dec 9, 2008 at 1:11 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
>> Those intel SSDs sound compelling.  I've been waiting for SSDs to get
>> competitive price and performance wise for a while, and when the
>> intels came out and I read the first benchmarks I immediately began
>> scheming.  Sadly, that was right after we're ordered our new 16 drive
>> servers, and I didn't have time to try something new and hope it would
>> work.  Now that the servers are up and running, we'll probably look at
>> adding the SSDs next summer before our high load period begins.
>
> The idea of SSDs is interesting. However I think I will wait for all the
> other early adopters to figure out the problems before I start
> suggesting them to clients.
>
> Hard drives work, their cheap and fast. I can get 25 spindles, 15k in a
> 3U with controller and battery backed cache for <$10k.

This may be a little off-topic, but I'd be interested in hearing more
details about how you (or others) would do this...  manufacturer,
model, configuration?  How many hard drives do you need to get 25
spindles?  And where can you get that many 15K hard drives for under
$10K?  My lack of experience in this area is showing here, but,
seriously, any suggestions appreciated.

...Robert

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: db server load
Next
From: david@lang.hm
Date:
Subject: Re: Need help with 8.4 Performance Testing