Re: compression in replication

Поиск
Список
Период
Сортировка
От Vijaykumar Jain
Тема Re: compression in replication
Дата
Msg-id CAM+6J97VdKJjaU2Uwn_GYThy23q0-29c2hjRrbZZh3_8eO-oJA@mail.gmail.com
обсуждение исходный текст
Ответы Re: compression in replication  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Список pgsql-admin


On Wed, 16 Jun 2021 at 13:41, Massimo Ortensi <mortensi@unimaticaspa.it> wrote:

is there any way to compress the traffic for streaming replication ?

--

I think this should help reduce traffic as it would decompress only when replaying.
I have not used it, but now that you asked, I will test it out.

Also, pg_basebackup supports gzip stream, and so does COPY but I do not see exclusive mention of compression support in replication slot details.
But if you try having a sidecar like envoyproxy or any tcpproxy per server, maybe communication between sidecars can be compressed but not db to sidecar.

[pg -> sidecar -> compressed wal stream]  -> [sidecar -> decompress -> pg]
I have not tried any option, FYI.


--
Thanks,
Vijay
Mumbai, India

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

Предыдущее
От: Vijaykumar Jain
Дата:
Сообщение: Re: How does vacuum full works if table is partitioned?
Следующее
От: Vijaykumar Jain
Дата:
Сообщение: Re: compression in replication