Re: [CAUTION: SUSPECT SENDER] RE: [CAUTION: SUSPECT SENDER] RE: BUG #19029: Replication Slot size keeps increasing while logical subscription works fine
От | Thadeus Anand |
---|---|
Тема | Re: [CAUTION: SUSPECT SENDER] RE: [CAUTION: SUSPECT SENDER] RE: BUG #19029: Replication Slot size keeps increasing while logical subscription works fine |
Дата | |
Msg-id | CANUywMFzW=M4OC++awgN-n=-9yk8z5pM=1XV+1QxThpGwiuXvw@mail.gmail.com обсуждение исходный текст |
Ответ на | RE: [CAUTION: SUSPECT SENDER] RE: BUG #19029: Replication Slot size keeps increasing while logical subscription works fine ("Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>) |
Ответы |
Re: [CAUTION: SUSPECT SENDER] RE: [CAUTION: SUSPECT SENDER] RE: BUG #19029: Replication Slot size keeps increasing while logical subscription works fine
|
Список | pgsql-bugs |
Hi,
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.
Thadeus Anand.
On Mon, 25 Aug, 2025, 3:19 pm Hayato Kuroda (Fujitsu), <kuroda.hayato@fujitsu.com> wrote:
Dear Thadeus,
> Under the pg_replslot folder, each replication slot's folder increased
> simultaneously. There were 12 folders (two publications, six subscribers), and
> the total size increase was about 420 GB).
Oh, I misunderstood like that number of WAL files increased.
Let me do some more questions to diagnose your system.
Can you share us the logical_decoding_work_mem on the publisher side? You can obtain via:
```
SHOW logical_decoding_work_mem;
```
Also, when you succeeded to reproduce, can you run the below command to see the
conent of the directory? ${DATA_PUB} can be tuned based on your environment.
```
du -sh ${DATA_PUB}/pg_replslot/*/*
```
This can see for which file uses the disk so much.
Best regards,
Hayato Kuroda
FUJITSU LIMITED
В списке pgsql-bugs по дате отправления: