pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: Hardware recommendations to scale to silly load
Date: Wed, 27 Aug 2003 22:07:20 -0400
Message-ID: <m3ptiqlelj.fsf@chvatal.cbbrowne.com> (raw)
References: <1061948112.15800.53.camel@gibraltar.mattclark.net>
	<Pine.LNX.4.33.0308270909500.1338-100000@css120.ihs.com>

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!"



view thread (45+ messages)  latest in thread

Message-ID: <m3ptiqlelj.fsf@chvatal.cbbrowne.com>
Permalink:  ../m3ptiqlelj.fsf@chvatal.cbbrowne.com/
Also on:    postgresql.org/message-id/m3ptiqlelj.fsf@chvatal.cbbrowne.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: cbbrowne@acm.org
  Subject: Re: Hardware recommendations to scale to silly load
  In-Reply-To: <m3ptiqlelj.fsf@chvatal.cbbrowne.com>
  References: <1061948112.15800.53.camel@gibraltar.mattclark.net> <Pine.LNX.4.33.0308270909500.1338-100000@css120.ihs.com> <m3ptiqlelj.fsf@chvatal.cbbrowne.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox