Re: Hardware recommendations to scale to silly load - Mailing list pgsql-performance

From Christopher Browne
Subject Re: Hardware recommendations to scale to silly load
Date
Msg-id m3ptiqlelj.fsf@chvatal.cbbrowne.com
Whole thread Raw
In response to Hardware recommendations to scale to silly load  (matt <matt@ymogen.net>)
List pgsql-performance
After takin a swig o' Arrakan spice grog, scott.marlowe@ihs.com
("scott.marlowe") belched out... :-):
> whether you like it or not, you're gonna need heavy iron if you need
> to do this all in one hour once a week.

The other thing worth considering is trying to see if there is a way
of partitioning the workload across multiple hosts.

At the point that you start going past hardware that is
"over-the-counter commodity" stuff, the premiums start getting pretty
high.  Dual-CPU Intel boxes are pretty cheap compared to buncha-CPU
Sparc boxes.

If some sort of segmentation of the workload can be done, whether by
area code, postal code, or perhaps the last couple digits of the
caller's phone number, or even a "round robin," it's likely to be a
lot cheaper to get an array of 4 Dual-Xeon boxes with 8 disk drives
apiece than a Sun/HP/IBM box with 16 CPUs.
--
let name="cbbrowne" and tld="ntlug.org" in name ^ "@" ^ tld;;
http://cbbrowne.com/info/linuxxian.html
"Show me... show me... show me... COMPUTERS!"

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Hardware recommendations to scale to silly load
Next
From: Bill Moran
Date:
Subject: Re: Hardware recommendations to scale to silly load