Re: 2-phase commit

Поиск
Список
Период
Сортировка
От Satoshi Nagayasu
Тема Re: 2-phase commit
Дата
Msg-id 20031011042626.6019bff2.pgsql@snaga.org
обсуждение исходный текст
Ответ на Re: 2-phase commit  (Andrew Sullivan <andrew@libertyrms.info>)
Ответы Re: 2-phase commit  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: compile warning
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [Fwd: [BUGS] pg_autovacuum segv]