Re: libpq compression

From: Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>
To: "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: libpq compression
Date: 2020-10-21 13:15:24
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 06.10.2020 9:34, Andrey M. Borodin wrote:
>> 26 марта 2019 г., в 19:46, Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> написал(а):
>> Version of the patch correctly working when no compression algorithm are avaiable.
> Thanks for this work, Konstantin.
> PFA rebased version of this patch.
> This compression seems very important to reduce network-induced replication lag.
> Recently I've found out that small installation suffer from huge latency spike when archive_timeout occurs.
> How this happens? archive_timeout emits segment switch, which pads current segment with zeroes. Now these zeroes need to be replicated to standbys, without compression. Transfer of zeroes causes long waits for synchronous replication (up to 1s with network restricted to 16Mbps).
> Also replication compression will reduce overall cross-AZ traffic of HA installations.
> So I'm considering following plan for 2020: implement this protocol in Odyssey and send patches to drivers to enable early access to this feature.
> Best regards, Andrey Borodin.

Rebased version of the patch is attached.
I am going to resubmit it to the next CF.

Attachment Content-Type Size
libpq-compression-17.patch text/x-patch 42.7 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2020-10-21 14:30:45 Re: A new function to wait for the backend exit after termination
Previous Message Magnus Hagander 2020-10-21 13:13:36 Re: A new function to wait for the backend exit after termination