Re: MultiXact\SLRU buffers configuration - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: MultiXact\SLRU buffers configuration
Date
Msg-id E6EEC639-9B91-4FB6-A857-96B17E9900ED@yandex-team.ru
Whole thread Raw
In response to Re: MultiXact\SLRU buffers configuration  (Yura Sokolov <y.sokolov@postgrespro.ru>)
Responses Re: MultiXact\SLRU buffers configuration
Re: MultiXact\SLRU buffers configuration
List pgsql-hackers

> On 21 Jul 2022, at 18:00, Yura Sokolov <y.sokolov@postgrespro.ru> wrote:
>
> In this case simple buffer increase does help. But "buckets"
> increase performance gain.
Yura, thank you for your benchmarks!
We already knew that patch can save the day on pathological workloads, now we have a proof of this.
Also there's the evidence that user can blindly increase size of SLRU if they want (with the second patch). So there's
noneed for hard explanations on how to tune the buffers size. 

Thomas, do you still have any doubts? Or is it certain that SLRU will be replaced by any better subsystem in 16?


Best regards, Andrey Borodin.


pgsql-hackers by date:

Previous
From: Nikita Malakhov
Date:
Subject: Re: Pluggable toaster
Next
From: Michael Paquier
Date:
Subject: Re: Collect ObjectAddress for ATTACH DETACH PARTITION to use in event trigger