Re: Speedup twophase transactions

Nikhil Sontakke <nikhils@2ndquadrant.com>

From: Nikhil Sontakke <nikhils@2ndquadrant.com>

To: Michael Paquier <michael.paquier@gmail.com>

Cc: Stas Kelvich <s.kelvich@postgrespro.ru>, Simon Riggs <simon@2ndquadrant.com>, PostgreSQL mailing lists <pgsql-hackers@postgresql.org>, Jesper Pedersen <jesper.pedersen@redhat.com>, Robert Haas <robertmhaas@gmail.com>

Date: 2017-01-26T08:02:48Z

Lists: pgsql-hackers

>> Umm, AFAICS, CheckPointTwoPhase() does not get called in the "standby
>> promote" code path.
>
> CreateRestartPoint() calls it via CheckPointGuts() while in recovery.

May be that I am missing something.

But, I put the recovery process and the checkpointer process of the
standby under gdb with breakpoints on these functions, but both did
not hit CreateRestartPoint() as well as CheckPointGuts() when I issued
a promote :-|

Regards,
Nikhils
-- 
 Nikhil Sontakke                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Commits

Speedup 2PC recovery by skipping two phase state files in normal path
- 728bd991c3c4 10.0 landed
Add tests for two-phase commit
- 30820982b295 10.0 landed
Improve grammar of message about two-phase state files.
- 38c363adf497 10.0 landed
Speedup 2PC by skipping two phase state files in normal path
- 978b2f65aa12 9.6.0 cited