More scalable multixacts buffers and locking

Edit
Comment/Review
Change Status
ID 2627
Title More scalable multixacts buffers and locking
Topic Performance
Created 2020-06-30 11:21:14
Last modified 2024-04-07 12:52:28 (8 months, 2 weeks ago)
Latest email 2024-04-07 19:13:12 (8 months, 2 weeks ago)
Status
2024-03: Committed
2024-01: Moved to next CF
2023-11: Moved to next CF
2023-09: Moved to next CF
2023-07: Moved to next CF
2023-03: Moved to next CF
2023-01: Moved to next CF
2022-11: Moved to next CF
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-11: Moved to next CF
2021-09: Moved to next CF
2021-07: Moved to next CF
2021-03: Moved to next CF
2021-01: Moved to next CF
2020-11: Moved to next CF
2020-09: Moved to next CF
2020-07: Moved to next CF
Target version
Authors Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness)
Reviewers Become reviewer
Committer Álvaro Herrera (alvherre)
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/2627
git checkout commitfest/cf/2627
Emails
MultiXact\SLRU buffers configuration
First at 2020-05-08 16:36:40 by "Andrey M. Borodin" <x4mmm at yandex-team.ru>
Latest at 2024-04-07 19:13:12 by "Andrey M. Borodin" <x4mmm at yandex-team.ru>
Latest attachment (v2-0003-Test-multixact-CV-sleep.patch) at 2024-02-03 17:32:45 from "Andrey M. Borodin" <x4mmm at yandex-team.ru>
    Attachment (v2-0003-Test-multixact-CV-sleep.patch) at 2024-02-03 17:32:45 from "Andrey M. Borodin" <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (0001-Add-conditional-variable-to-wait-for-next-MultXact-o.patch) at 2024-01-28 18:17:16 from "Andrey M. Borodin" <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (v24-0001-Divide-SLRU-buffers-into-8-associative-banks.patch) at 2023-01-09 04:19:14 from Andrey Borodin <amborodin86 at gmail.com> (Patch: Yes)
    Attachment (v23-0001-bucketed-SLRUs-simplified.patch) at 2022-08-19 15:48:41 from i.lazarev at postgrespro.ru (Patch: Yes)
    Attachment (v22-0006-bucketed-SLRUs-simplified_patch.patch) at 2022-08-16 19:36:27 from i.lazarev at postgrespro.ru (Patch: Yes)
    Attachment (slru-ballast.sql) at 2022-07-21 13:00:20 from Yura Sokolov <y.sokolov at postgrespro.ru> (Patch: No)
    Attachment (v20-0001-Make-all-SLRU-buffer-sizes-configurable.patch) at 2022-01-16 05:36:08 from Andrey Borodin <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (v19-0003-Pack-SLRU-page_number-page_status-and-page_dirty.patch) at 2022-01-15 07:16:59 from Andrey Borodin <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (v-18-0001-Make-all-SLRU-buffer-sizes-configurable.patch) at 2021-12-26 10:09:59 from Andrey Borodin <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (v17-0002-Divide-SLRU-buffers-into-n-associative-banks.patch) at 2021-04-11 18:37:21 from Andrey Borodin <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (v16-0001-Add-a-buffer-mapping-table-for-SLRUs.patch) at 2021-04-08 00:30:41 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Add-a-buffer-mapping-table-for-SLRUs.patch) at 2021-04-07 05:59:19 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Add-a-buffer-mapping-table-for-SLRUs.patch) at 2021-04-01 03:40:16 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Make-all-SLRU-buffer-sizes-configurable.patch) at 2021-03-26 20:26:40 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Make-all-SLRU-buffer-sizes-configurable.patch) at 2021-03-26 03:46:06 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Make-all-SLRU-buffer-sizes-configurable.patch) at 2021-03-25 01:03:38 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Make-all-SLRU-buffer-sizes-configurable.patch) at 2021-03-24 21:31:56 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Make-all-SLRU-buffer-sizes-configurable.patch) at 2021-03-12 12:44:02 from Andrey Borodin <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (v9-0001-Make-all-SLRU-buffer-sizes-configurable.patch) at 2021-02-15 17:17:40 from Andrey Borodin <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (v8-0004-Add-GUCs-to-tune-MultiXact-SLRUs.patch) at 2020-12-14 06:31:32 from Andrey Borodin <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (postgresql_conf_multixact_buffers_GUCs.patch) at 2020-12-13 09:17:51 from Gilles Darold <gilles at darold.net> (Patch: Yes)
    Attachment (v7-0001-Use-shared-lock-in-GetMultiXactIdMembers-for-offs.patch) at 2020-12-10 14:45:56 from Gilles Darold <gilles at darold.net> (Patch: Yes)
    Attachment (v1106-0001-Use-shared-lock-in-GetMultiXactIdMembers-for-o.patch) at 2020-12-08 17:52:52 from Andrey Borodin <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (collect-wait-events.sh) at 2020-11-10 18:07:07 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
    Attachment (v6-0001-Use-shared-lock-in-GetMultiXactIdMembers-for-offs.patch) at 2020-10-28 07:34:58 from Andrey Borodin <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (v6-0001-Use-shared-lock-in-GetMultiXactIdMembers-for-offs.patch) at 2020-10-27 17:23:26 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Use-shared-lock-in-GetMultiXactIdMembers-for-offs.patch) at 2020-10-27 17:02:20 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Use-shared-lock-in-GetMultiXactIdMembers-for-offsets.patch) at 2020-10-26 01:05:26 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Use-shared-lock-in-GetMultiXactIdMembers-for-offs.patch) at 2020-08-28 18:08:34 from Anastasia Lubennikova <a.lubennikova at postgrespro.ru> (Patch: Yes)
    Attachment (v2-0001-Use-shared-lock-in-GetMultiXactIdMembers-for-offs.patch) at 2020-07-08 07:03:54 from "Andrey M. Borodin" <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (mxid_wait_instead_of_sleep.patch) at 2020-05-15 00:03:33 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-GUCs-to-tune-MultiXact-SLRUs.patch) at 2020-05-11 11:17:58 from "Andrey M. Borodin" <x4mmm at yandex-team.ru> (Patch: Yes)
History
When Who What
2024-04-07 12:52:28 Andrey Borodin (x4m) Closed in commitfest 2024-03 with status: Committed
2024-04-07 12:52:28 Andrey Borodin (x4m) Changed committer to alvherre
2024-02-01 18:40:04 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2024-01-27 01:40:31 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2023-12-04 09:16:23 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 17:34:17 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-09-02 06:51:42 Peter Eisentraut (petere) Changed reviewers to
2023-08-02 19:40:59 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-04-09 02:32:25 Greg Stark (stark) Closed in commitfest 2023-03 with status: Moved to next CF
2023-01-31 16:15:52 vigneshwaran C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2023-01-09 04:24:25 Andrey Borodin (x4m) New status: Needs review
2023-01-06 06:08:16 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2022-12-04 01:36:17 Andrey Borodin (x4m) Closed in commitfest 2022-11 with status: Moved to next CF
2022-10-13 09:21:36 Yura Sokolov (funny_falcon) New status: Needs review
2022-10-12 21:09:01 Andrey Borodin (x4m) Changed authors to Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness)
2022-10-12 08:30:49 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-10-12 08:30:45 Michael Paquier (michael-kun) New status: Waiting on Author
2022-08-01 16:49:59 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Moved to next CF
2022-04-08 15:17:15 Greg Stark (stark) Closed in commitfest 2022-03 with status: Moved to next CF
2022-02-02 16:29:55 Julien Rouhaud (rjuju) Closed in commitfest 2022-01 with status: Moved to next CF
2022-01-16 16:28:27 Justin Pryzby (justinpryzby) New status: Needs review
2022-01-14 09:28:43 Julien Rouhaud (rjuju) New status: Waiting on Author
2021-12-03 07:32:54 Michael Paquier (michael-kun) Closed in commitfest 2021-11 with status: Moved to next CF
2021-10-06 13:16:11 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Moved to next CF
2021-08-03 02:26:54 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-07 with status: Moved to next CF
2021-04-08 12:21:58 Thomas Munro (macdice) Closed in commitfest 2021-03 with status: Moved to next CF
2021-03-12 16:16:32 Andrey Borodin (x4m) New status: Needs review
2021-03-11 17:07:54 Gilles Darold (darold) New status: Waiting on Author
2021-02-01 12:35:45 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2020-12-12 09:45:30 Gilles Darold (darold) Added darold as reviewer
2020-12-01 14:30:05 Anastasia Lubennikova (lubennikovaav) Removed lubennikovaav from reviewers
2020-12-01 14:30:01 Anastasia Lubennikova (lubennikovaav) Closed in commitfest 2020-11 with status: Moved to next CF
2020-12-01 14:29:54 Anastasia Lubennikova (lubennikovaav) New status: Needs review
2020-10-07 15:09:33 Anastasia Lubennikova (lubennikovaav) New status: Waiting on Author
2020-09-30 07:06:23 Michael Paquier (michael-kun) Closed in commitfest 2020-09 with status: Moved to next CF
2020-09-30 07:06:20 Michael Paquier (michael-kun) New status: Needs review
2020-08-28 18:13:00 Anastasia Lubennikova (lubennikovaav) Added lubennikovaav as reviewer
2020-08-02 21:27:23 Daniel Gustafsson (d_gustafsson) New status: Waiting on Author
2020-08-02 21:27:16 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2020-07 with status: Moved to next CF
2020-08-02 21:27:12 Daniel Gustafsson (d_gustafsson) New status: Needs review
2020-07-02 12:02:55 Daniel Gustafsson (d_gustafsson) New status: Waiting on Author
2020-06-30 11:22:06 Andrey Borodin (x4m) Changed authors to Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m)
2020-06-30 11:21:14 Andrey Borodin (x4m) Attached mail thread 2BEC2B3F-9B61-4C1D-9FB5-5FAB0F05EF86@yandex-team.ru
2020-06-30 11:21:14 Andrey Borodin (x4m) Created patch record
Edit
Comment/Review
Change Status