Re: [CAUTION: SUSPECT SENDER] RE: [CAUTION: SUSPECT SENDER] RE: BUG #19029: Replication Slot size keeps increasing while logical subscription works fine

Hi,

We created the publications and subscriptions again last night after
restarting the publisher and all the subscribers.

So far, everything seems to be working fine, and the replication slot
folders remain at 4 KB each.

I did not change anything, and didn't do anything differently this time. In
any case, I will monitor this closely and let you know if any
malfunction.occurs.

Thanks and regards,
Thadeus Anand.

On Mon, Aug 25, 2025 at 5:05 PM Thadeus Anand <thadeus(at)rmkv(dot)com> wrote:

> Hi,
>
> In the meanwhile, I'm sharing my configuration file here, just in case you
> need to know any particular setting.
>
> Again, thank you very much for taking the time to help.
>
> Thadeus Anand.
>
>
> On Mon, Aug 25, 2025 at 4:43 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
> wrote:
>
>> On Mon, Aug 25, 2025 at 3:34 PM Thadeus Anand <thadeus(at)rmkv(dot)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.
>>
>