From: Brendan Duddridge <brendan@clickspace.com>
To: David Lang <dlang@invendra.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Hardware/OS recommendations for large databases (
Date: Mon, 28 Nov 2005 20:19:41 -0700
Message-ID: <3017A204-1BAF-4E62-ADA6-695E34557645@clickspace.com> (raw)
In-Reply-To: <Pine.LNX.4.62.0511271903180.2807@qnivq.ynat.uz>
References: <BFB0BF1B.1495C%llonergan@greenplum.com>
<179B5137-F0BB-4037-A5AD-3459B914E580@clickspace.com>
<Pine.LNX.4.62.0511271903180.2807@qnivq.ynat.uz>
Hi David,
Thanks for your reply. So how is that different than something like
Slony2 or pgcluster with multi-master replication? Is it similar
technology? We're currently looking for a good clustering solution
that will work on our Apple Xserves and Xserve RAIDs.
Thanks,
____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 | brendan@clickspace.com
ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB T2G 0V9
http://www.clickspace.com
On Nov 27, 2005, at 8:09 PM, David Lang wrote:
> On Mon, 28 Nov 2005, Brendan Duddridge wrote:
>
>> Forgive my ignorance, but what is MPP? Is that part of Bizgres? Is
>> it possible to upgrade from Postgres 8.1 to Bizgres?
>
> MPP is the Greenplum propriatary extention to postgres that spreads
> the data over multiple machines, (raid, but with entire machines
> not just drives, complete with data replication within the cluster
> to survive a machine failing)
>
> for some types of queries they can definantly scale lineraly with
> the number of machines (other queries are far more difficult and
> the overhead of coordinating the machines shows more. this is one
> of the key things that the new version they recently announced the
> beta for is supposed to be drasticly improving)
>
> early in the year when I first looked at them their prices were
> exorbadent, but Luke says I'm wildly mistake on their current
> prices so call them for details
>
> it uses the same interfaces as postgres so it should be a drop in
> replacement to replace a single server with a cluster.
>
> it's facinating technology to read about.
>
> I seem to remember reading that one of the other postgres companies
> is also producing a clustered version of postgres, but I don't
> remember who and know nothing about them.
>
> David Lang
>
Attachments:
smime.p7s (application/pkcs7-signature, 2.3K) download
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: brendan@clickspace.com, dlang@invendra.net
Subject: Re: Hardware/OS recommendations for large databases (
In-Reply-To: <3017A204-1BAF-4E62-ADA6-695E34557645@clickspace.com>
References: <BFB0BF1B.1495C%llonergan@greenplum.com> <179B5137-F0BB-4037-A5AD-3459B914E580@clickspace.com> <Pine.LNX.4.62.0511271903180.2807@qnivq.ynat.uz> <3017A204-1BAF-4E62-ADA6-695E34557645@clickspace.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