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.
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 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.
