From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-admin@postgresql.org
Subject: Re: Hardware and OS for postgresql
Date: Mon, 22 Mar 2004 11:40:24 -0500
Message-ID: <20040322164024.GD11738@phlogiston.dyndns.org> (raw)
In-Reply-To: <2f57764a.0403201952.5df3b33b@posting.google.com>
References: <2f57764a.0403201952.5df3b33b@posting.google.com>
On Sat, Mar 20, 2004 at 07:52:08PM -0800, Ghazan Haider wrote:
> (1) Scaling in which direction will help postgresql best, given the
> queries are CPU, memory, io and disk-intensive? I understand dual-CPUs
> will help in certain circumstances, but say for large subqueries which
> are built in the memory, will it help to have a server in which there
> are memory segments dedicated to each CPUs? In this regard, does
> anyone know of a specific Sun Ultra, RS/6000 HP or Dell server whose
> architecture is especially favorable to Postgresql or databases in
> general?
I think dedicating memory to individual CPUs is likely to be
counter-productive. You won't be able to share the memory for
filesystem buffers, which are the things most likely to give you the
biggest return.
I _can_ tell you that I've recently had an opportunity to work with a
fairly large IBM RS/6000 (P650), and it is one fast machine. It's
sort of unfair to compare it to UltraSPARC II machines, but I
certainly am impressed as compared to Sun's E4500.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
--Brad Holland
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-admin@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: Hardware and OS for postgresql
In-Reply-To: <20040322164024.GD11738@phlogiston.dyndns.org>
References: <2f57764a.0403201952.5df3b33b@posting.google.com> <20040322164024.GD11738@phlogiston.dyndns.org>
* 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