Re: compression in replication - Mailing list pgsql-admin

From Vijaykumar Jain
Subject Re: compression in replication
Date
Msg-id CAM+6J97VdKJjaU2Uwn_GYThy23q0-29c2hjRrbZZh3_8eO-oJA@mail.gmail.com
Whole thread Raw
Responses Re: compression in replication
List 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 by date:

Previous
From: Vijaykumar Jain
Date:
Subject: Re: How does vacuum full works if table is partitioned?
Next
From: Vijaykumar Jain
Date:
Subject: Re: compression in replication