Re: 2-phase commit

Andrew Sullivan <andrew(at)libertyrms(dot)info> wrote:
> On Fri, Oct 10, 2003 at 09:46:35AM +0900, Tatsuo Ishii wrote:
> > Satoshi, the only guy who made a trial implementation of 2PC for
> > PostgreSQL, has already showed that 2PC is not that slow.
>
> If someone has a fast implementation, so much the better. I'm not
> opposed to fast implementations!

The pgbench results of my experimental 2PC implementation
and plain postgresql are available.

PostgreSQL 7.3
http://snaga.org/pgsql/pgbench/pgbench-REL7_3.log

Experimental 2PC in PostgreSQL 7.3
http://snaga.org/pgsql/pgbench/pgbench-TPC0_0_2.log

I can't see a grave overhead from this comparison.

>
> A
>
> --
> ----
> Andrew Sullivan 204-4141 Yonge Street
> Afilias Canada Toronto, Ontario Canada
> <andrew(at)libertyrms(dot)info> M2P 2A8
> +1 416 646 3304 x110
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

--
NAGAYASU Satoshi <snaga(at)snaga(dot)org>