Re: 2-phase commit - Mailing list pgsql-hackers

From Satoshi Nagayasu
Subject Re: 2-phase commit
Date
Msg-id 20031011042626.6019bff2.pgsql@snaga.org
Whole thread Raw
In response to Re: 2-phase commit  (Andrew Sullivan <andrew@libertyrms.info>)
Responses Re: 2-phase commit
List pgsql-hackers
Andrew Sullivan <andrew@libertyrms.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@libertyrms.info>                              M2P 2A8
>                                          +1 416 646 3304 x110
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
> 


-- 
NAGAYASU Satoshi <snaga@snaga.org>



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: compile warning
Next
From: Bruce Momjian
Date:
Subject: Re: [Fwd: [BUGS] pg_autovacuum segv]