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.pg@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=Qv61wA@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
