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 по дате отправления: