Re: Hardware/OS recommendations for large databases ( - Mailing list pgsql-performance

From David Lang
Subject Re: Hardware/OS recommendations for large databases (
Date
Msg-id Pine.LNX.4.62.0511271903180.2807@qnivq.ynat.uz
Whole thread Raw
In response to Re: Hardware/OS recommendations for large databases (  (Brendan Duddridge <brendan@clickspace.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: David Lang
Date:
Subject: Re: Hardware/OS recommendations for large databases (
Next
From: "energumen@buaa.edu.cn"
Date:
Subject: index auto changes after copying data ?