Re: Two weeks to feature freeze - Mailing list pgsql-hackers

From The Hermit Hacker
Subject Re: Two weeks to feature freeze
Date
Msg-id 20030623000919.W95856@hub.org
Whole thread Raw
In response to Re: Two weeks to feature freeze  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
On Sun, 22 Jun 2003, Bruce Momjian wrote:

> Tom Lane wrote:
> > Bruce Momjian <pgman@candle.pha.pa.us> 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
...


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: O_DIRECT in freebsd
Next
From: Tom Lane
Date:
Subject: Re: O_DIRECT in freebsd