pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ross J. Reedstrom <reedstrm@rice.edu>
To: Grigoriy G. Vovk <grigoriy.vovk@linustech.com.cy>
Cc: Robert.Farrugia@go.com.mt
Cc: pgsql-admin@postgresql.org
Subject: Re: Distributed databases
Date: Wed, 8 Aug 2001 09:39:07 -0500
Message-ID: <20010808093907.A27709@rice.edu> (raw)
In-Reply-To: <20010808093629.K546-100000@callisto.internal.linustech.com.cy>
References: <20010808093629.K546-100000@callisto.internal.linustech.com.cy>

On Wed, Aug 08, 2001 at 09:40:21AM +0300, Grigoriy G. Vovk wrote:
> Aug 8, 07:17 +0200, Robert.Farrugia@go.com.mt wrote:
> 
> > Does anyone know of any package which allows a database to be distributed
> > over a number of machines (for e.g. depending on row values, rows from 0 -
> > 100 on machine A, rows 100 - 200 on machine B, etc) ?  Preferably this
> > package should also offer a means to automatically split the query over all
> > the machines in the domain ?
> 
> Yes, I do, I know a package which does perfect exactly what you want.
> It is IBM DB2 Extended Enterprise Edition :))
> 
> I don't think you are able to find something similar to DB2 for
> PostgreSQL. I'll be happy to be wrong....

Not in the current PostgreSQL source. There was an academic project built
on Postgres95, called Mariposa, that did exactly what you describe. It
was commericalized as Cohera (www.cohera.com) which has retargetted as a
'business content integration solution provider' whatever that means.

They've always targetted the Large Enterprise market, so much so that
I can't find pricing info on their site (if you have to ask ...)

I took a look at porting Mariposa to the current PostgreSQL source about
a year ago, but it was beyond my skills and knowledge at the time. It's
another one of the interesting bits of Postgres history that needs to
be dusted off and looked at again.

Ross



view thread (7+ messages)  latest in thread

Message-ID: <20010808093907.A27709@rice.edu>
Permalink:  ../20010808093907.A27709@rice.edu/
Also on:    postgresql.org/message-id/20010808093907.A27709@rice.edu

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: reedstrm@rice.edu, grigoriy.vovk@linustech.com.cy, Robert.Farrugia@go.com.mt
  Subject: Re: Distributed databases
  In-Reply-To: <20010808093907.A27709@rice.edu>

* 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