Re: compression in replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I tried with wal_compression=on but seems to have no effect

Massimo Ortensi - Responsabile ICT
logo

Via Cristoforo Colombo, 21 - 40131, Bologna 
Tel.  051 4195069
Cell.  3351092560


mortensi@xxxxxxxxxxxxxxx

Il 16/06/2021 16.54, Vijaykumar Jain ha scritto:


On Wed, 16 Jun 2021 at 13:41, Massimo Ortensi <mortensi@xxxxxxxxxxxxxxx> 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

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux