On Wed, Oct 11, 2023 at 4:34 PM Dilip Kumar <dilipbal...@gmail.com> wrote: > > The small size of the SLRU buffer pools can sometimes become a > performance problem because it’s not difficult to have a workload > where the number of buffers actively in use is larger than the > fixed-size buffer pool. However, just increasing the size of the > buffer pool doesn’t necessarily help, because the linear search that > we use for buffer replacement doesn’t scale, and also because > contention on the single centralized lock limits scalability. > > There is a couple of patches proposed in the past to address the > problem of increasing the buffer pool size, one of the patch [1] was > proposed by Thomas Munro where we make the size of the buffer pool > configurable.
In my last email, I forgot to give the link from where I have taken the base path for dividing the buffer pool in banks so giving the same here[1]. And looking at this again it seems that the idea of that patch was from Andrey M. Borodin and the idea of the SLRU scale factor were introduced by Yura Sokolov and Ivan Lazarev. Apologies for missing that in the first email. [1] https://commitfest.postgresql.org/43/2627/ -- Regards, Dilip Kumar EnterpriseDB: http://www.enterprisedb.com
