Re: BUG #19029: Replication Slot size keeps increasing while logical subscription works fine

On Mon, Aug 25, 2025 at 10:39 AM Thadeus Anand <thadeus(at)rmkv(dot)com> wrote:
>
> Hi,
>
> The number of replication slots does not increase at all. But the size of each folder keeps increasing simultaneously.
>

Can you share an example as to what you mean by folder keeps
increasing? Is the slot size on disk is increasing?

> When I restart a subscriber, the size of the respective slot resets, then immediately grows up to the size of the slots of other subscribers.
>

To understand the problem you are facing, we need to see some real
data on the size. Can you share the output of pg_replication_slots
both before and after the folder's size increase?

> The table data is properly synchronized across the locations, and the status of the replication remains as 'streaming'. So, effectively, the logical replication works (which it wasn't in version 17.5), but the replication slot isn't resetting.
>

Is it possible to share a reproducer or some steps to reproduce the problem?

--
With Regards,
Amit Kapila.