KnownAssignedXidsGetAndSetXmin performance

Edit
ID 3271
Title KnownAssignedXidsGetAndSetXmin performance
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Tags Performance
Created 2021-08-02 21:04:39
Last modified 2025-05-04 13:51:29 (1 year ago)
Latest email 2022-11-30 06:53:19 (3 years ago)
Status
2022-11 (2022-11-01 – 2022-11-30): Returned with feedback
2022-09 (2022-09-01 – 2022-09-30): Moved to different CF
2022-07 (2022-07-01 – 2022-07-31): Moved to different CF
2022-03 (2022-03-01 – 2022-03-31): Moved to different CF
2022-01 (2022-01-01 – 2022-01-31): Moved to different CF
2021-09 (2021-09-01 – 2021-09-30): Moved to different CF
Target version
Authors Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu)
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
2025-05-04 13:51:29 Michail Nikolaev (nkey) Changed authors to Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu)
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