Horton

Re: Speedup twophase transactions

Stas Kelvich <s.kelvich@postgrespro.ru>

View thread View on postgr.es
From: Stas Kelvich <s.kelvich@postgrespro.ru>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: Michael Paquier <michael.paquier@gmail.com>, David Steele <david@pgmasters.net>, PostgreSQL mailing lists <pgsql-hackers@postgresql.org>, Alvaro Herrera <alvherre@2ndquadrant.com>, Andres Freund <andres@anarazel.de>
Date: 2016-04-08T13:45:12Z
Lists: pgsql-hackers 
> On 08 Apr 2016, at 16:36, Simon Riggs <simon@2ndQuadrant.com> wrote:
> 
> On 7 April 2016 at 07:29, Michael Paquier <michael.paquier@gmail.com> wrote:
> 
> With the test case attached in my case the COMMIT PREPARED record does
> not even get replayed.
> 
> I was surprised to see this in the test...
> 
>    sleep 2; # wait for changes to arrive on slave 
> 
> I think the test framework needs a WaitForLSN function to allow us to know for certain that something has been delivered.

Yes, test framework already has that function. That was just quick script to reproduce bug, that Michael faced.
If there will be deterministic way to reproduce that bug, i'll rework it and move to 00X_twophase.pl

-- 
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company

Commits

  1. Speedup 2PC recovery by skipping two phase state files in normal path

  2. Add tests for two-phase commit

  3. Improve grammar of message about two-phase state files.

  4. Speedup 2PC by skipping two phase state files in normal path