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

Re: postgresql clustering

From: "Luke Lonergan" <LLonergan(at)greenplum(dot)com>
To: "Daniel Duvall" <the(dot)liberal(dot)media(at)gmail(dot)com>,pgsql-hackers(at)postgresql(dot)org
Subject: Re: postgresql clustering
Date: 2005-09-29 15:17:02
Message-ID: 3E37B936B592014B978C4415F90D662D0C4279@MI8NYCMAIL06.Mi8.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Daniel,

>From what I've researched, the concepts and practices seem to fall
> under one of two abstract categorizations: fail-over (ok...
> high-availability), and parallel execution (high-performance... sure).
> While some consider the implementation of only one of these to qualify
> a cluster, others seem to demand that a "true" cluster must
> implement both.

If you want to get a high degree of parallelism, 10s or 100s of machines are required.   At that size, you must have fault tolerance to make the ystem usable.

> What I'm really after is a DB setup that does fail-over and parallel
> execution.  Your setup sounds like it would gracefully handle the
> former, but cannot achieve the latter.  Perhaps I'm simply asking too
> much of a free software setup.

We've spent the last 3 years developing a parallel database that does both and I can tell you that it takes a huge development effort to get it right for the general audience.  Bizgres MPP is capable of handling ANSI SQL, is ACID compliant and scales to tens of terabytes, but it's not free (sorry about that).  It is tons cheaper than Oracle or Teradata though, and it's based on Postgres.

- Luke


Responses

pgsql-hackers by date

Next:From: Tony CadutoDate: 2005-09-29 15:17:55
Subject: Re: Found small issue with OUT params
Previous:From: Bruce MomjianDate: 2005-09-29 15:17:00
Subject: Re: Added documentation about caching, reliability

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