Re: Reducing bandwidth usage of database replication

P {margin-top:0;margin-bottom:0;}

Hi all,

I want to use the postgres-native logical replication to have multiple clients receive and send data to a central database.

Real-time is far less important than network usage, and with my current test setup it appears both instances communicate frequently if a subscription is active, even if nothing is happening.

Is there a good way to reduce data usage, for example by limiting the amount of keep-alive messages? One database will likely be idle most of the time.

I estimated the current solution to idle at around 1.4MiB per day. Ideally it would use less than 100KiB a day.