KnownAssignedXidsGetAndSetXmin performance

Edit
ID 3271
Title KnownAssignedXidsGetAndSetXmin performance
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Performance
Tags
Created 2021-08-02 21:04:39
Last modified 2025-05-04 13:51:29 (5 months ago)
Latest email 2022-11-30 06:53:19 (2 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