Re: [CAUTION: SUSPECT SENDER] RE: [CAUTION: SUSPECT SENDER] RE: BUG #19029: Replication Slot size keeps increasing while logical subscription works fine
Amit Kapila <amit.kapila16@gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
To: Thadeus Anand <thadeus@rmkv.com>
Cc: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>,
pgsql-bugs@lists.postgresql.org
Date: 2025-08-25T11:13:28Z
Lists: pgsql-bugs
On Mon, Aug 25, 2025 at 3:34 PM Thadeus Anand <thadeus@rmkv.com> wrote: > > The logical_decoding_work_mem at the publisher is currently set at 1 GB. > > I remember setting this a while ago as part of my struggle to get rid of the memory allocation issue. > Hmm, this means that your transaction size has a large number of changes which leads to spilling of changes. This makes another question of Kuroda-San more important, which is to show the size and contents of pg_replslot. I have tried to check the fixes done in 17.5 and 17.6 but I don't see any obvious change which could lead to such a problem. I could be missing something which we can try to find with more information and probably if you can share a test. -- With Regards, Amit Kapila.