Re: Reducing bandwidth usage of database replication

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Reducing bandwidth usage of database replication
Дата
Msg-id f3b7d9b9-a620-11d2-ffdc-e07b4b9821c1@gmail.com
обсуждение исходный текст
Ответ на Reducing bandwidth usage of database replication  (Sascha Zenglein <zenglein@gessler.de>)
Ответы AW: Reducing bandwidth usage of database replication  (Sascha Zenglein <zenglein@gessler.de>)
Список pgsql-general
On 11/2/22 09:56, Sascha Zenglein wrote:
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.

1.4MiB/day is 17 bytes per second.  That's not too much.

--
Angular momentum makes the world go 'round.

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

Предыдущее
От: Sascha Zenglein
Дата:
Сообщение: Reducing bandwidth usage of database replication
Следующее
От: Bryn Llewellyn
Дата:
Сообщение: Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all"