Compress KnownAssignedXids more frequently

Edit
Title Compress KnownAssignedXids more frequently
Topic Performance
Created 2022-09-17 06:28:25
Last modified 2022-11-29 20:43:58 (1 year, 4 months ago)
Latest email 2022-11-30 06:53:19 (1 year, 4 months ago)
Status
2022-11: Committed
Target version
Authors Simon Riggs (simon), Michail Nikolaev (nkey)
Reviewers Tom Lane (tgl)Become reviewer
Committer Tom Lane (tgl)
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-29 20:43:58 Tom Lane (tgl) Closed in commitfest 2022-11 with status: Committed
2022-11-29 20:43:53 Tom Lane (tgl) Added tgl as reviewer
2022-11-28 22:04:20 Tom Lane (tgl) Added tgl as committer
2022-11-15 17:17:50 Michail Nikolaev (nkey) New status: Ready for Committer
2022-09-17 06:29:10 Simon Riggs (simon) Changed authors to Simon Riggs (simon), Michail Nikolaev (nkey)
2022-09-17 06:28:25 Simon Riggs (simon) Attached mail thread CALdSSPgahNUD_=pB_j=1zSnDBaiOtqVfzo8Ejt5J_k7qZiU1Tw@mail.gmail.com
2022-09-17 06:28:25 Simon Riggs (simon) Created patch record
Edit