Skip site navigation (1) Skip section navigation (2)

Re: Hardware recommendations to scale to silly load

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware recommendations to scale to silly load
Date: 2003-08-28 02:07:20
Message-ID: m3ptiqlelj.fsf@chvatal.cbbrowne.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
After takin a swig o' Arrakan spice grog, scott(dot)marlowe(at)ihs(dot)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!"

In response to

pgsql-performance by date

Next:From: Bill MoranDate: 2003-08-28 02:26:01
Subject: Re: Hardware recommendations to scale to silly load
Previous:From: Christopher BrowneDate: 2003-08-28 01:32:16
Subject: Re: Hardware recommendations to scale to silly load

pgsql-hackers by date

Next:From: Bill MoranDate: 2003-08-28 02:26:01
Subject: Re: Hardware recommendations to scale to silly load
Previous:From: Christopher BrowneDate: 2003-08-28 01:32:16
Subject: Re: Hardware recommendations to scale to silly load

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group