Hi, On Tue, Aug 26, 2025 at 02:56:14PM +0530, Ashutosh Bapat wrote: > On Mon, Aug 25, 2025 at 6:28 PM Bertrand Drouvot > <bertranddrouvot...@gmail.com> wrote: > > > I didn't know this is how it works. Thanks for correcting me. In that > > > case, I think we should > > > add a column in pg_stat_replication_slots reporting the number of > > > times the memory limit is reached since the last reset. I am +0.5 on > > > it being useful. > > > > Thanks. With this in place one could get a ratio like > > total_txns/total_txns_that_exceeds. > > That could help to see if reaching logical_decoding_work_mem is rare or > > frequent enough. If frequent, then maybe there is a need to adjust > > logical_decoding_work_mem. > > > > We are discussing some improvements to pg_stat_replication_slots over > at [1]. Would you be able to create a patch reporting the number of > times logical_decoding_work_mem is reached, in the patchset being > discussed there? > > [1] > https://www.postgresql.org/message-id/CAExHW5s6KntzUyUoMbKR5dgwRmdV2Ay_2+AnTgYGAzo=qv6...@mail.gmail.com
Thanks for pointing me to this thread, I'll look at it and propose a patch to report the number of times logical_decoding_work_mem is reached. Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com
