Re: PostgreSQL clustering VS MySQL clustering

Jean-Max Reymond <jmreymond@gmail.com>

From: Jean-Max Reymond <jmreymond@gmail.com>
To: Steve Wampler <swampler@noao.edu>
Cc: Mitch Pirtle <mitch.pirtle@gmail.com>, pgsql-performance@postgresql.org
Date: 2005-01-20T19:35:44Z
Lists: pgsql-performance
On Thu, 20 Jan 2005 12:13:17 -0700, Steve Wampler <swampler@noao.edu> wrote:
> Mitch Pirtle wrote:

> But that's not enough, because you're going to be running separate
> postgresql backends on the different hosts, and there are
> definitely consistency issues with trying to do that.  So far as
> I know (right, experts?) postgresql isn't designed with providing
> distributed consistency in mind (isn't shared memory used for
> consistency, which restricts all the backends to a single host?).

yes, you're right: you'll need a Distributed Lock Manager and an
application to manage it , Postgres ?