On Mon, Mar 3, 2025 at 9:10 PM Ajin Cherian <itsa...@gmail.com> wrote: > > On Thu, Feb 20, 2025 at 8:42 PM Hayato Kuroda (Fujitsu) > <kuroda.hay...@fujitsu.com> wrote: > >
I confirmed with tests that with the patch, a lot less disk space is used when there are lots of unpublished changes and the subscription is not configured to be streaming. HEAD code: Initial disk usage in replication slot directory: 4.0K /home/ajin/dataoss/pg_replslot/mysub BEGIN INSERT 0 1000000 COMMIT Final disk usage in replication slot directory: 212M /home/ajin/dataoss/pg_replslot/mysub Patched code: Initial disk usage in replication slot directory: 4.0K /home/ajin/dataoss/pg_replslot/mysub BEGIN INSERT 0 1000000 COMMIT Final disk usage in replication slot directory: 4.0K /home/ajin/dataoss/pg_replslot/mysub Attaching the test script used. Regards, Ajin Cherian Fujitsu Australia
test_disk_usage.sh
Description: Binary data
