SLRU optimizations

Edit
Title SLRU optimizations
Topic Performance
Created 2023-10-25 05:16:38
Last modified 2024-02-28 16:45:43 (2 months ago)
Latest email 2024-04-03 16:01:28 (3 weeks, 6 days 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
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