Re: Two Phase Commit support

Neil Conway <neilc@samurai.com>

From: Neil Conway <neilc@samurai.com>
To: wsheldah@lexmark.com
Cc: Cristóvão Dalla Costa <cbraga@bsi.com.br>, Robert Treat <xzilla@users.sourceforge.net>, stephen@cass-ltd.co.uk, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2002-10-28T23:19:02Z
Lists: pgsql-general
wsheldah@lexmark.com writes:
> I agree with Cristóvão. Also, two-phase commit only makes sense in the
> context of multiple database servers which are replicating to each other in
> real time. Once postgresql has replication in place then they should
> probably start considering two-phase commit; unless they decide to roll out
> both at once of course. ;-)

The Pgreplication project is in the process of implementing a new
eager, multi-master replication design that should be a lot more
scalable than 2PC -- see here for more info:

  http://citeseer.nj.nec.com/330257.html

BTW, the Pgreplication homepage is here:

  http://gborg.postgresql.org/project/pgreplication/projdisplay.php

Cheers,

Neil

-- 
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC