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 ?