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, 7 months ago)

Latest email 2017-04-05 00:22:34 (7 years, 7 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