Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock

From:	Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To:	Dilip Kumar <dilipbalaut(at)gmail(dot)com>
Cc:	tender wang <tndrwang(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject:	Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock
Date:	2024-02-04 14:06:33
Message-ID:	202402041406.3avy4htmv7l4@alvherre.pgsql
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2023-10-11 11:04:37 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎  2023-10-11 12:27:20 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>   2023-10-12 12:46:05 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎   2023-10-24 16:04:13 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>    2023-10-24 17:04:51 from Nathan Bossart <nathandbossart(at)gmail(dot)com>    2023-10-25 05:04:15 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>     2023-10-30 06:20:40 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎      2023-11-03 05:28:43 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎       2023-11-08 05:21:38 from Amul Sul <sulamul(at)gmail(dot)com>        2023-11-08 05:46:03 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>      2023-11-04 20:07:52 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>       2023-11-06 04:09:54 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>        2023-11-06 07:35:55 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru> 📎         2023-11-06 09:21:04 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>          2023-11-06 09:31:41 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>           2023-11-06 11:14:32 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>            2023-11-06 11:24:42 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>            2023-11-08 05:09:34 from Amul Sul <sulamul(at)gmail(dot)com>        2023-11-08 11:40:43 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎         2023-11-09 16:08:51 from Robert Haas <robertmhaas(at)gmail(dot)com>          2023-11-10 04:46:29 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>         2023-11-16 09:41:48 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>          2023-11-17 07:39:03 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>           2023-11-17 11:11:24 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎            2023-11-17 12:46:29 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>             2023-11-18 10:28:58 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>              2023-11-18 19:00:04 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>            2023-11-19 07:09:18 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>             2023-11-20 04:32:47 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>           2023-11-17 13:58:32 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>            2023-11-20 08:51:47 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎             2023-11-20 09:07:18 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>              2023-11-20 11:12:43 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>               2023-11-21 08:33:46 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎                2023-11-23 06:04:15 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎                 2023-11-24 04:47:54 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                  2023-11-24 09:07:33 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎                   2023-11-29 09:40:48 from tender wang <tndrwang(at)gmail(dot)com>                    2023-11-29 09:59:05 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                     2023-11-29 11:28:07 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                      2023-11-30 10:00:15 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎                       2023-12-11 05:11:47 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎                        2023-12-12 13:28:51 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                         2023-12-13 04:56:23 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                         2023-12-13 12:19:11 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                          2023-12-14 11:06:03 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                           2023-12-14 11:25:46 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                           2023-12-14 14:56:17 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎                         2023-12-18 17:04:07 from Robert Haas <robertmhaas(at)gmail(dot)com>                          2023-12-18 17:30:11 from Robert Haas <robertmhaas(at)gmail(dot)com>                           2023-12-18 17:53:43 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                            2023-12-18 18:18:47 from Robert Haas <robertmhaas(at)gmail(dot)com>                           2023-12-19 05:34:42 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                            2023-12-22 13:14:17 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                             2024-01-02 14:23:27 from Robert Haas <robertmhaas(at)gmail(dot)com>                              2024-01-02 18:10:04 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                               2024-01-02 18:30:43 from Robert Haas <robertmhaas(at)gmail(dot)com>                              2024-01-03 05:08:06 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                               2024-01-03 13:45:48 from Robert Haas <robertmhaas(at)gmail(dot)com>                        2023-12-14 03:12:46 from Amul Sul <sulamul(at)gmail(dot)com>                         2023-12-14 08:23:12 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎                          2023-12-15 05:15:36 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎                         2023-12-14 09:01:52 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                          2023-12-14 09:28:01 from tender wang <tndrwang(at)gmail(dot)com>                           2023-12-14 09:35:37 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                            2023-12-14 11:32:06 from tender wang <tndrwang(at)gmail(dot)com>                             2023-12-14 11:56:50 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                        2024-01-08 11:25:20 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                         2024-01-08 13:18:09 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                          2024-01-08 15:42:34 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                           2024-01-10 13:20:20 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎                            2024-01-23 05:35:48 from Dilip Kumar <dilipbalaut(at)gmail(dot)com> 📎                             2024-01-25 16:22:07 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                              2024-01-25 16:33:43 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                               2024-01-29 05:56:40 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                2024-01-31 23:31:34 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                 2024-02-01 09:49:29 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                  2024-02-01 10:03:34 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                   2024-02-01 10:14:00 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                    2024-02-01 10:42:39 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                     2024-02-01 11:04:06 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                      2024-02-02 06:06:45 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                       2024-02-04 13:38:38 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                        2024-02-04 14:06:33 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                         2024-02-04 14:14:11 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                        2024-02-04 17:40:17 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                                        2024-02-05 07:47:11 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                         2024-02-06 10:53:12 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                          2024-02-06 11:35:16 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                           2024-02-06 15:25:10 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                            2024-02-07 05:58:58 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                             2024-02-07 06:45:53 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                                             2024-02-07 10:19:29 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                              2024-02-07 10:37:07 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                               2024-02-22 18:43:00 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                2024-02-23 07:36:26 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                 2024-02-23 11:02:23 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                                                  2024-02-23 11:48:11 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                 2024-02-23 11:04:36 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                  2024-02-26 16:16:44 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                   2024-02-27 09:56:35 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                    2024-02-27 16:03:12 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                     2024-02-27 16:17:11 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                                                      2024-02-27 16:26:07 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                       2024-02-27 17:33:18 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                        2024-02-27 17:51:58 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                                                        2024-02-27 18:11:07 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                         2024-02-28 03:50:13 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                        2024-02-29 04:04:04 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                         2024-02-29 10:46:42 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                          2024-03-03 13:58:39 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                           2024-03-04 22:14:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                            2024-03-04 22:41:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                             2024-03-05 11:18:05 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                        2024-04-03 12:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                         2024-04-03 14:10:08 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                          2024-04-03 14:18:35 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                                           2024-04-03 16:01:28 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                              2024-01-25 17:28:19 from Robert Haas <robertmhaas(at)gmail(dot)com>                             2024-01-26 17:38:04 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                              2024-01-26 18:21:18 from Andrey Borodin <x4mmm(at)yandex-team(dot)ru>                              2024-01-29 06:01:32 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>       2023-11-08 09:17:23 from Ants Aasma <ants(at)cybertec(dot)at>        2023-11-08 09:32:48 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>        2023-11-09 11:25:13 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>         2023-11-10 04:47:49 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>          2023-11-10 16:43:32 from Nathan Bossart <nathandbossart(at)gmail(dot)com>  2023-10-14 04:13:35 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>   2023-10-20 04:10:35 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>    2023-10-25 12:28:09 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>     2023-10-25 12:43:27 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v2-0001-Use-atomics-for-SlruSharedData-latest_page_number.patch	text/x-diff	9.0 KB

In response to

• Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock at 2024-02-04 13:38:38 from Alvaro Herrera

Responses

• Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock at 2024-02-04 14:14:11 from Alvaro Herrera

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Alvaro Herrera	2024-02-04 14:14:11	Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock
Previous Message	Alvaro Herrera	2024-02-04 13:38:38	Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock