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

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: BUG #19029: Replication Slot size keeps increasing while logical subscription works fine
Дата
Msg-id CAA4eK1Kt38N-wxAD3W4e4evbJBXuviHz5NcS=1x2TFTV7WCugQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #19029: Replication Slot size keeps increasing while logical subscription works fine  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #19029: Replication Slot size keeps increasing while logical subscription works fine
Список pgsql-bugs
On Mon, Aug 25, 2025 at 10:39 AM Thadeus Anand <thadeus@rmkv.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
slotsof 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'tresetting. 
>

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

--
With Regards,
Amit Kapila.



В списке pgsql-bugs по дате отправления: