Skip site navigation (1) Skip section navigation (2)

Re: Hardware/OS recommendations for large databases (

From: Brendan Duddridge <brendan(at)clickspace(dot)com>
To: David Lang <dlang(at)invendra(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware/OS recommendations for large databases (
Date: 2005-11-29 03:19:41
Message-ID: 3017A204-1BAF-4E62-ADA6-695E34557645@clickspace.com (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)clickspace(dot)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
>

In response to

Responses

pgsql-performance by date

Next:From: David BorehamDate: 2005-11-29 03:30:53
Subject: Re: Hardware/OS recommendations for large databases (
Previous:From: David GagnonDate: 2005-11-29 02:16:52
Subject: Re: Please help with this explain analyse...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group