From: Luke Lonergan <llonergan@greenplum.com>
To: James Mello <james@haydrian.com>
To: William Yu <wyu@talisys.com>
To: pgsql-performance@postgresql.org
Subject: Re: Hardware/OS recommendations for large databases (
Date: Tue, 15 Nov 2005 22:11:39 -0800
Message-ID: <BFA00D9B.13C69%llonergan@greenplum.com> (raw)
In-Reply-To: <775F825B46B551499DC75DC4E92F80AB0E3623@jupiter.ad.haydrian.com>
James,
On 11/15/05 11:07 AM, "James Mello" <james@haydrian.com> wrote:
> Unless there was a way to guarantee consistency, it would be hard at
> best to make this work. Convergence on large data sets across boxes is
> non-trivial, and diffing databases is difficult at best. Unless there
> was some form of automated way to ensure consistency, going 8 ways into
> separate boxes is *very* hard. I do suppose that if you have fancy
> storage (EMC, Hitachi) you could do BCV or Shadow copies. But in terms
> of commodity stuff, I'd have to agree with Merlin.
It¹s a matter of good software that handles the distribution / parallel
query optimization / distributed transactions and management features.
Combine that with a gigabit ethernet switch and it works we routinely get
50x speedup over SMP on OLAP / Decision Support workloads.
Regards,
- Luke
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: llonergan@greenplum.com, james@haydrian.com, wyu@talisys.com
Subject: Re: Hardware/OS recommendations for large databases (
In-Reply-To: <BFA00D9B.13C69%llonergan@greenplum.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