SLRU optimizations

Edit
ID 4626
Title SLRU optimizations
Topic Performance
Created 2023-10-25 05:16:38
Last modified 2024-02-28 16:45:43 (8 months, 3 weeks ago)
Latest email 2024-04-03 16:01:28 (7 months, 2 weeks ago)
Status
2024-03: Committed
2024-01: Moved to next CF
2023-11: Moved to next CF
Target version
Authors Dilip Kumar (dilip.kumar), Andrey Borodin (x4m)
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/4626
git checkout commitfest/cf/4626
Emails
SLRU optimization - configurable buffer pool and partitioning the SLRU lock
First at 2023-10-11 11:04:37 by Dilip Kumar <dilipbalaut at gmail.com>
Latest at 2024-04-03 16:01:28 by Alvaro Herrera <alvherre at alvh.no-ip.org>
Latest attachment (0001-Fix-zeroing-of-pg_serial-page-without-SLRU-bank-lock.patch) at 2024-04-03 14:10:08 from Alvaro Herrera <alvherre at alvh.no-ip.org>
    Attachment (0001-Fix-zeroing-of-pg_serial-page-without-SLRU-bank-lock.patch) at 2024-04-03 14:10:08 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (0001-extra_desc.patch) at 2024-02-29 10:46:42 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v21-0001-Rename-SLRU-elements-in-pg_stat_slru.patch) at 2024-02-27 17:33:18 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (0001-Rename-SLRU-elements-in-pg_stat_slru.patch) at 2024-02-27 16:03:12 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v20-0001-Make-SLRU-buffer-sizes-configurable.patch) at 2024-02-26 16:16:44 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v19-0001-Make-SLRU-buffer-sizes-configurable.patch) at 2024-02-22 18:43:00 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v18-enlarge-slru-buffers.patch) at 2024-02-06 15:25:10 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v3-0001-Use-atomics-for-SlruSharedData-latest_page_number.patch) at 2024-02-04 14:14:11 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v2-0001-Use-atomics-for-SlruSharedData-latest_page_number.patch) at 2024-02-04 14:06:33 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (0001-Use-atomics-for-SlruSharedData-latest_page_number.patch) at 2024-01-31 23:31:34 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v16-slru-optimization.patch) at 2024-01-25 16:33:43 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v15-slru-optimization.patch) at 2024-01-25 16:22:07 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v14-0002-Divide-SLRU-buffers-into-banks.patch) at 2024-01-23 05:35:48 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: Yes)
    Attachment (v13-0002-Divide-SLRU-buffers-into-banks.patch) at 2024-01-10 13:20:20 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Make-all-SLRU-buffer-sizes-configurable.patch) at 2023-12-15 05:15:36 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: Yes)
    Attachment (test_clog_group_commit.sh) at 2023-12-14 14:56:17 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: No)
    Attachment (v11-0002-Divide-SLRU-buffers-into-banks.patch) at 2023-12-14 08:23:12 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: Yes)
    Attachment (v10-0002-Divide-SLRU-buffers-into-banks.patch) at 2023-12-11 05:11:47 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Make-all-SLRU-buffer-sizes-configurable.patch) at 2023-11-30 10:00:15 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: Yes)
    Attachment (v8-0002-Divide-SLRU-buffers-into-banks.patch) at 2023-11-24 09:07:33 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: Yes)
    Attachment (0001-test-group-update-poc-no-for-commit.patch) at 2023-11-23 06:04:15 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Make-all-SLRU-buffer-sizes-configurable.patch) at 2023-11-21 08:33:46 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: Yes)
    Attachment (image.png) at 2023-11-20 08:51:47 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: No)
    Attachment (v6-0002-Divide-SLRU-buffers-into-banks.patch) at 2023-11-17 11:11:24 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: Yes)
    Attachment (v5-0002-Divide-SLRU-buffers-into-banks.patch) at 2023-11-08 11:40:43 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: Yes)
    Attachment (0001-Implement-benchmark_slru_page_readonly-to-assess-SLR.patch) at 2023-11-06 07:35:55 from "Andrey M. Borodin" <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (v4-0005-Ensure-slru-buffer-slots-are-in-multiple-of-numbe.patch) at 2023-11-03 05:28:43 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: Yes)
    Attachment (v3-0005-Merge-bank-locks-array-with-buffer-locks-array.patch) at 2023-10-30 06:20:40 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: Yes)
    Attachment (v2-0002-bank-wise-slru-locks.patch) at 2023-10-12 12:46:05 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: Yes)
    Attachment (v1-0003-Introduce-bank-wise-LRU-counter.patch) at 2023-10-11 11:04:37 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: Yes)
History
When Who What
2024-02-28 16:45:43 Álvaro Herrera (alvherre) Closed in commitfest 2024-03 with status: Committed
2024-02-01 17:52:03 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2024-01-16 13:48:28 Álvaro Herrera (alvherre) Added alvherre as committer
2023-12-04 09:49:38 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-25 05:18:07 Dilip Kumar (dilip.kumar) Changed authors to Dilip Kumar (dilip.kumar), Andrey Borodin (x4m)
2023-10-25 05:18:07 Dilip Kumar (dilip.kumar) Changed name to SLRU optimizations
2023-10-25 05:16:38 Dilip Kumar (dilip.kumar) Attached mail thread CAFiTN-vzDvNz=ExGXz6gdyjtzGixKSqs0mKHMmaQ8sOSEFZ33A@mail.gmail.com
2023-10-25 05:16:38 Dilip Kumar (dilip.kumar) Created patch record
Edit