On Sun, 22 Jun 2003, Bruce Momjian wrote:

> Tom Lane wrote:
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > I sure want two-phase commit.  I don't remember it as being rejected,
> > > and we certainly need it, independent of replication.
> >
> > Is 2PC a real-world solution to any real-world problem?  I have never
> > seen a satisfactory explanation of what you do when you've reported that
> > you're ready to commit and no confirmation ever comes back.  Sooner or
> > later you must violate the protocol in one direction or the other (ie,
> > commit without confirmation or roll back in violation of your promise
> > of being able to commit).
> >
> > I think it's a cool-sounding phrase that does not actually work in
> > practice.
> I think 2PC can be used to build more complex features, like using
> dblink for cross-db modification queries.

That was my understanding too ... as soon as you try and go distributed,
you need some method of ensuring that the data is constant across them all

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to