More scalable multixacts buffers and locking

Edit

Title

Topic

Performance

Created

2020-06-30 11:21:14

Last modified

2023-04-09 02:32:25 (2 months ago)

Latest email

2023-01-11 17:13:43 (4 months, 4 weeks ago)

Status

2023-07: Needs review

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

Ivan Lazarev (avaness), Andrey Borodin (x4m), Kyotaro Horiguchi (horiguti)

Reviewers

Gilles Darold (darold)Become reviewer

Committer

Links

Emails

MultiXact\SLRU buffers configuration: First at 2020-05-08 16:36:40 by "Andrey M. Borodin" <x4mmm at yandex-team.ru>
Latest at 2023-01-11 17:13:43 by Andrey Borodin <amborodin86 at gmail.com>
Latest 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>
    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
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