Improve performance of 2PC recovery, take 2

Edit
ID 915
Title Improve performance of 2PC recovery, take 2
Topic Performance
Created 2016-12-16 11:07:21
Last modified 2017-04-04 19:58:49 (7 years, 8 months ago)
Latest email 2017-04-05 00:22:34 (7 years, 8 months ago)
Status
2017-03: Committed
2017-01: Moved to next CF
Target version
Authors Michael Paquier (michael-kun), Stas Kelvich (kelvich), Nikhil Sontakke (nikkhils)
Reviewers Simon Riggs (simon), Michael Paquier (michael-kun), Nikhil Sontakke (nikkhils)Become reviewer
Committer Simon Riggs (simon)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/915
git checkout commitfest/cf/915
Emails
Speedup twophase transactions
First at 2015-12-09 18:44:28 by Stas Kelvich <s.kelvich at postgrespro.ru>
Latest at 2017-04-05 00:22:34 by Michael Paquier <michael.paquier at gmail.com>
Latest attachment (twophase_recovery_shmem_280317.patch) at 2017-03-28 05:10:05 from Nikhil Sontakke <nikhils at 2ndquadrant.com>
    Attachment (twophase_recovery_shmem_280317.patch) at 2017-03-28 05:10:05 from Nikhil Sontakke <nikhils at 2ndquadrant.com> (Patch: Yes)
    Attachment (twophase_recovery_shmem_michael.patch) at 2017-03-22 02:10:59 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (twophase_recovery_shmem_150317.patch) at 2017-03-15 07:48:29 from Nikhil Sontakke <nikhils at 2ndquadrant.com> (Patch: Yes)
    Attachment (twophase_recovery_shmem_110317.patch) at 2017-03-11 10:26:25 from Nikhil Sontakke <nikhils at 2ndquadrant.com> (Patch: Yes)
    Attachment (twophase_recovery_shmem_020217.patch) at 2017-02-02 06:07:20 from Nikhil Sontakke <nikhils at 2ndquadrant.com> (Patch: Yes)
    Attachment (twophase_typo.patch) at 2017-02-01 08:29:25 from Nikhil Sontakke <nikhils at 2ndquadrant.com> (Patch: Yes)
    Attachment (twophase_recovery_list_2_23017.patch) at 2017-01-23 12:00:59 from Nikhil Sontakke <nikhils at 2ndquadrant.com> (Patch: Yes)
    Attachment (twophase_recovery_list_2.diff) at 2017-01-23 11:26:41 from Stas Kelvich <s.kelvich at postgrespro.ru> (Patch: Yes)
    Attachment (twophase_recovery_list.diff) at 2016-12-17 22:41:50 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (twophase_replay.v7.patch) at 2016-09-16 17:45:19 from Stas Kelvich <s.kelvich at postgrespro.ru> (Patch: Yes)
    Attachment (twophase_replay.v6.patch) at 2016-09-06 01:41:27 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (twophase_replay.v5.patch) at 2016-04-13 14:31:25 from Stas Kelvich <s.kelvich at postgrespro.ru> (Patch: Yes)
    Attachment (2pc_master_logs.log) at 2016-04-12 12:47:40 from Michael Paquier <michael.paquier at gmail.com> (Patch: No)
    Attachment (twophase_replay.v4.patch) at 2016-04-11 10:16:37 from Stas Kelvich <s.kelvich at postgrespro.ru> (Patch: Yes)
    Attachment (twophase_replay.v4.patch) at 2016-04-08 13:09:23 from Stas Kelvich <s.kelvich at postgrespro.ru> (Patch: Yes)
    Attachment (twophase_recovery_bug_2.pl) at 2016-04-07 06:29:13 from Michael Paquier <michael.paquier at gmail.com> (Patch: No)
    Attachment (twophase_recovery_bug.pl) at 2016-04-06 09:47:18 from Stas Kelvich <s.kelvich at postgrespro.ru> (Patch: No)
    Attachment (twophase_replay.v2.diff) at 2016-03-18 16:50:54 from Stas Kelvich <s.kelvich at postgrespro.ru> (Patch: Yes)
    Attachment (replica_lag.png) at 2016-01-26 12:43:42 from Stas Kelvich <s.kelvich at postgrespro.ru> (Patch: No)
    Attachment (1pc.svg.gz) at 2016-01-12 14:48:05 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: No)
    Attachment (2pc_remove_prepXacts.v1.patch) at 2016-01-12 05:14:04 from Simon Riggs <simon at 2ndQuadrant.com> (Patch: Yes)
    Attachment (2pc_optimize.v4.patch) at 2016-01-11 19:57:58 from Simon Riggs <simon at 2ndQuadrant.com> (Patch: Yes)
    Attachment (xa.png) at 2016-01-11 18:40:03 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: No)
    Attachment (2pc_optimize.v2.patch) at 2016-01-09 15:29:11 from Simon Riggs <simon at 2ndQuadrant.com> (Patch: Yes)
    Attachment (2pc_xlog.diff) at 2016-01-09 12:26:27 from Stas Kelvich <s.kelvich at postgrespro.ru> (Patch: Yes)
    Attachment (2pc_xlog.v2.diff) at 2015-12-10 12:41:39 from Stas Kelvich <s.kelvich at postgrespro.ru> (Patch: Yes)
    Attachment (2pc_xlog.diff) at 2015-12-09 18:44:28 from Stas Kelvich <s.kelvich at postgrespro.ru> (Patch: Yes)

Annotations

When Who Mail Annotation
2016-03-31 12:00:19 Jesper Pedersen (jpedersen) From Stas Kelvich <s.kelvich@postgrespro.ru>
at 2016-03-30 13:19:01
Contains v3 of the patch
2017-01-24 11:54:43 Nikhil Sontakke (nikkhils) From Nikhil Sontakke <nikhils@2ndquadrant.com>
at 2017-01-23 12:00:59
Contains typo fixed, latest version of this patch. Is the latest.
History
When Who What
2017-04-04 19:58:49 Simon Riggs (simon) Closed in commitfest 2017-03 with status: Committed
2017-03-28 06:09:54 Michael Paquier (michael-kun) New status: Ready for Committer
2017-03-27 06:35:04 Simon Riggs (simon) New status: Waiting on Author
2017-03-27 06:34:58 Simon Riggs (simon) Added simon as committer
2017-03-22 05:32:37 Michael Paquier (michael-kun) New status: Needs review
2017-03-22 05:32:34 Michael Paquier (michael-kun) Changed authors to Michael Paquier (michael-kun), Stas Kelvich (kelvich), Nikhil Sontakke (nikkhils)
2017-03-13 06:45:39 Michael Paquier (michael-kun) New status: Waiting on Author
2017-03-11 10:30:27 Nikhil Sontakke (nikkhils) New status: Needs review
2017-01-31 03:11:11 Michael Paquier (michael-kun) New status: Waiting on Author
2017-01-31 03:11:03 Michael Paquier (michael-kun) Closed in commitfest 2017-01 with status: Moved to next CF
2017-01-31 03:10:58 Michael Paquier (michael-kun) New status: Needs review
2017-01-24 11:54:43 Nikhil Sontakke (nikkhils) Added annotation "Contains typo fixed, latest version of this patch. Is the latest. " to CAMGcDxf8Bn9ZPBBJZba9wiyQq-Qk5uqq=VjoMnRnW5s+fKST3w@mail.gmail.com
2017-01-23 06:28:08 Nikhil Sontakke (nikkhils) Added nikkhils as reviewer
2017-01-04 21:27:02 Simon Riggs (simon) Changed name to Improve performance of 2PC recovery, take 2
2017-01-03 13:19:41 Simon Riggs (simon) Added simon as reviewer
2016-12-27 01:34:19 Michael Paquier (michael-kun) Changed reviewers to Michael Paquier (michael-kun)
2016-12-27 01:34:10 Michael Paquier (michael-kun) New status: Waiting on Author
2016-12-17 14:42:10 Peter Eisentraut (petere) Changed authors to Stas Kelvich (kelvich)
2016-12-16 11:07:21 Stas Kelvich (kelvich) Attached mail thread 74355FCF-AADC-4E51-850B-47AF59E0B215@postgrespro.ru
2016-12-16 11:07:21 Stas Kelvich (kelvich) Created patch record
Edit