Horton

Re: Speedup twophase transactions

Simon Riggs <simon@2ndquadrant.com>

View thread View on postgr.es
From: Simon Riggs <simon@2ndQuadrant.com>
To: Michael Paquier <michael.paquier@gmail.com>
Cc: Stas Kelvich <s.kelvich@postgrespro.ru>, David Steele <david@pgmasters.net>, PostgreSQL mailing lists <pgsql-hackers@postgresql.org>, Alvaro Herrera <alvherre@2ndquadrant.com>, Simon Riggs <simon@2ndquadrant.com>, Andres Freund <andres@anarazel.de>
Date: 2016-04-08T13:36:19Z
Lists: pgsql-hackers 
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.

-- 
Simon Riggs                http://www.2ndQuadrant.com/
<http://www.2ndquadrant.com/>
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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