Re: Two-phase commit issues - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Two-phase commit issues
Date
Msg-id 200505201937.39738.josh@agliodbs.com
Whole thread Raw
In response to Re: Two-phase commit issues  (David Garamond <lists@zara.6.isreserved.com>)
Responses Re: Two-phase commit issues  (José Orlando Pereira <jop@lsd.di.uminho.pt>)
List pgsql-hackers
Tom,

> > [ Shrug... ]  I remain of the opinion that 2PC is a solution in search
> > of a problem, because it does not solve the single point of failure
> > issue (just moves same from the database to the 2PC controller).
> > But some people want it anyway, and they aren't going to be satisfied
> > that we are an "enterprise grade" database until we can check off this
> > particular bullet point.  As long as the implementation doesn't impose
> > any significant costs when not being used (which AFAICS Heikki's method
> > doesn't), I think we gotta hold our noses and do it.

2PC is a key to supporting 3rd-party replication tools, like C-JDBC.   And is
useful for some other use cases, like slow-WAN-based financial transactions.
We know you don't like it, Tom.  ;-)

--
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: patches for items from TODO list
Next
From: Josh Berkus
Date:
Subject: Re: patches for items from TODO list