Re: libpq compression - Mailing list pgsql-hackers

From Andres Freund
Subject Re: libpq compression
Date
Msg-id 20201102195059.w6qnplbyargqwbp2@alap3.anarazel.de
Whole thread Raw
In response to Re: libpq compression  (Andrey Borodin <x4mmm@yandex-team.ru>)
Responses Re: libpq compression  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
List pgsql-hackers
Hi,

On 2020-10-31 22:25:36 +0500, Andrey Borodin wrote:
> But the price of compression is 1 cpu for 500MB/s (zstd). With a
> 20Gbps network adapters cost of recompressing all traffic is at most
> ~4 cores.

It's not quite that simple, because presumably each connection is going
to be handled by one core at a time in the pooler. So it's easy to slow
down peak throughput if you also have to deal with TLS etc.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Explicit NULL dereference (src/backend/utils/adt/ruleutils.c)
Next
From: Peter Geoghegan
Date:
Subject: Re: vacuum -vs reltuples on insert only index