Compress KnownAssignedXids more frequently

Edit
ID 3902
Title Compress KnownAssignedXids more frequently
Topic Performance
Created 2022-09-17 06:28:25
Last modified 2022-11-29 20:43:58 (1 year, 11 months ago)
Latest email 2022-11-30 06:53:19 (1 year, 11 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 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/3902
git checkout commitfest/cf/3902
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