Re: MultiXact\SLRU buffers configuration

Поиск
Список
Период
Сортировка
От Andrey Borodin
Тема Re: MultiXact\SLRU buffers configuration
Дата
Msg-id E6EEC639-9B91-4FB6-A857-96B17E9900ED@yandex-team.ru
обсуждение исходный текст
Ответ на Re: MultiXact\SLRU buffers configuration  (Yura Sokolov <y.sokolov@postgrespro.ru>)
Ответы Re: MultiXact\SLRU buffers configuration
Re: MultiXact\SLRU buffers configuration
Список 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 по дате отправления:

Предыдущее
От: Nikita Malakhov
Дата:
Сообщение: Re: Pluggable toaster
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Collect ObjectAddress for ATTACH DETACH PARTITION to use in event trigger