From: William Yu <wyu@talisys.com>
To: pgsql-performance@postgresql.org
Subject: Re: Hardware/OS recommendations for large databases ( 5TB)
Date: Tue, 15 Nov 2005 10:57:05 -0800
Message-ID: <dldb20$2lau$1@news.hub.org> (raw)
In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3417DD898@Herge.rcsinc.local>
References: <6EE64EF3AB31D5448D0007DD34EEB3417DD898@Herge.rcsinc.local>
Merlin Moncure wrote:
>>You could instead buy 8 machines that total 16 cores, 128GB RAM and
>
> It's hard to say what would be better. My gut says the 5u box would be
> a lot better at handling high cpu/high concurrency problems...like your
> typical business erp backend. This is pure speculation of course...I'll
> defer to the experts here.
In this specific case (data warehouse app), multiple machines is the
better bet. Load data on 1 machine, copy to other servers and then use a
middleman to spread out SQL statements to each machine.
I was going to suggest pgpool as the middleman but I believe it's
limited to 2 machines max at this time. I suppose you could daisy chain
pgpools running on every machine.
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: wyu@talisys.com
Subject: Re: Hardware/OS recommendations for large databases ( 5TB)
In-Reply-To: <dldb20$2lau$1@news.hub.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