KnownAssignedXidsGetAndSetXmin performance

Edit

Title

Topic

Performance

Created

2021-08-02 21:04:39

Last modified

2022-11-15 17:19:04 (6 months, 3 weeks ago)

Latest email

2022-11-30 06:53:19 (6 months, 1 week ago)

Status

2022-11: Returned with feedback

2022-09: Moved to next CF

2022-07: Moved to next CF

2022-03: Moved to next CF

2022-01: Moved to next CF

2021-09: Moved to next CF

Target version

Authors

Michail Nikolaev (nkey)

Reviewers

Kirill Reshke (reshke), Andrey Borodin (x4mmm)Become reviewer

Committer

Links

Emails

Slow standby snapshot: First at 2021-05-20 08:52:47 by Кирилл Решке <reshkekirill at gmail.com>
Latest at 2022-11-30 06:53:19 by Simon Riggs <simon.riggs at enterprisedb.com>
Latest attachment (16.png) at 2022-11-28 07:19:31 from Michail Nikolaev <michail.nikolaev at gmail.com>
    Attachment (16.png) at 2022-11-28 07:19:31 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: No)
    Attachment (vnext-0001-Currently-KnownAssignedXidsGetAndSetXmin-requi.patch) at 2022-11-22 21:53:33 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (events_that_force_compression.v1.patch) at 2022-11-20 16:41:52 from Simon Riggs <simon.riggs at enterprisedb.com> (Patch: Yes)
    Attachment (WIP.png) at 2022-11-20 13:55:29 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: No)
    Attachment (WIP.png) at 2022-11-20 13:50:01 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: No)
    Attachment (WIP.patch) at 2022-11-20 13:45:13 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (0001-memory-barrier-instead-of-spinlock.patch) at 2022-11-16 12:23:46 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v8c-new-heuristic-to-compress-KnownAssignedXids.patch) at 2022-09-17 06:27:30 from Simon Riggs <simon.riggs at enterprisedb.com> (Patch: Yes)
    Attachment (v8-0001-Currently-KnownAssignedXidsGetAndSetXmin-requires.patch) at 2022-09-16 16:08:24 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Currently-KnownAssignedXidsGetAndSetXmin-requires.patch) at 2022-08-07 19:28:36 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (subx_optimize_KnownAssignedXidsRemoveTree.v2.patch) at 2022-08-02 15:18:44 from Simon Riggs <simon.riggs at enterprisedb.com> (Patch: Yes)
    Attachment (subx_compress_knownassignedxids_more_often.v2.patch) at 2022-07-29 15:08:38 from Simon Riggs <simon.riggs at enterprisedb.com> (Patch: Yes)
    Attachment (v6-0001-Currently-KnownAssignedXidsGetAndSetXmin-requires.patch) at 2022-07-19 21:12:39 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Optimize-KnownAssignedXidsGetAndSetXmin-by-mainta.patch) at 2022-03-31 23:18:41 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Use-linked-list-to-improve-KnownAssignedXids-perf.patch) at 2022-02-20 17:56:08 from Andrey Borodin <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (v3-0001-memory-barrier-instead-of-spinlock.patch) at 2021-11-21 18:58:29 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (runs-0-base.png) at 2021-11-14 12:09:43 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: No)
    Attachment (v2-0001-known-assignment-xid-next.patch) at 2021-11-09 21:15:42 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (know_xid_optimization.patch) at 2021-08-02 21:07:23 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (UseDoublyLinkedListInKnowAssingedXods.patch) at 2021-05-20 09:16:39 from Kirill Reshke <reshkekirill at gmail.com> (Patch: Yes)

History

When	Who	What
2022-11-15 17:19:04	Michail Nikolaev (nkey)	Closed in commitfest 2022-11 with status: Returned with feedback
2022-10-12 06:45:32	Michael Paquier (michael-kun)	Closed in commitfest 2022-09 with status: Moved to next CF
2022-08-01 17:16:50	Jacob Champion (jchampion)	Closed in commitfest 2022-07 with status: Moved to next CF
2022-04-08 23:38:26	Greg Stark (stark)	Closed in commitfest 2022-03 with status: Moved to next CF
2022-02-22 08:10:06	Michail Nikolaev (nkey)	New status: Ready for Committer
2022-02-02 16:33:45	Julien Rouhaud (rjuju)	Closed in commitfest 2022-01 with status: Moved to next CF
2021-11-27 09:03:00	Michail Nikolaev (nkey)	Changed reviewers to Кирилл Решке (reshke), Andrey Borodin (x4mmm)
2021-11-21 22:20:26	Alexander Korotkov (smagen)	Closed in commitfest 2021-09 with status: Moved to next CF
2021-11-21 19:03:13	Michail Nikolaev (nkey)	New status: Needs review
2021-10-01 06:40:38	Michael Paquier (michael-kun)	Closed in commitfest 2021-09 with status: Returned with feedback
2021-08-02 21:05:19	Michail Nikolaev (nkey)	Changed reviewers to Кирилл Решке (reshke)
2021-08-02 21:05:19	Michail Nikolaev (nkey)	Changed authors to Michail Nikolaev (nkey)
2021-08-02 21:04:39	Michail Nikolaev (nkey)	Attached mail thread CALdSSPgahNUD_=pB_j=1zSnDBaiOtqVfzo8Ejt5J_k7qZiU1Tw@mail.gmail.com
2021-08-02 21:04:39	Michail Nikolaev (nkey)	Created patch record

Edit