Re: 2-phase commit

From: Satoshi Nagayasu <pgsql(at)snaga(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: hlinnaka(at)iki(dot)fi, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 2-phase commit
Date: 2003-10-24 03:57:29
Message-ID: 3F98A329.4090808@snaga.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce,

Ok, I will write my proposal.

BTW, my 2PC work is now suspended because of my master thesis.
My master thesis will (must) be finished in next few months.

To finish 2PC work, I feel 2 or 3 months are needed after that.

Bruce Momjian wrote:
> Satoshi, can you get this ready for inclusion in 7.5? We need a formal
> proposal of how it will work from the user's perspective (new
> commands?), and how it will internally work. It seem Heikki Linnakangas
> has also started working on this and perhaps he can help.
>
> Ideally, we should have this proposal when we start 7.5 development in a
> few weeks.
>
> I know some people have concerns about 2-phase commit, from a
> performance perspective and from a network failure perspective, but I
> think there are enough people who want it that we should see how this
> can be implemented with the proper safeguards.
>
> ---------------------------------------------------------------------------
>
> Satoshi Nagayasu wrote:
>
>>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>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 6: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>
>

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2003-10-24 04:06:35 Re: 7.4 compatibility question
Previous Message Bruce Momjian 2003-10-24 03:30:45 Re: 2-phase commit