pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (173+ messages)  latest in thread

Message-ID: <3017A204-1BAF-4E62-ADA6-695E34557645@clickspace.com>
Permalink:  ../3017A204-1BAF-4E62-ADA6-695E34557645@clickspace.com/
Also on:    postgresql.org/message-id/3017A204-1BAF-4E62-ADA6-695E34557645@clickspace.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: 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