Re: Using compression on TCP transfer

On Tue, 2020-03-31 at 15:13 +0300, Andrus wrote:
> > It is a simple ALTER TABLE.
>
> Client is Visual FoxPro application. It sends data with trailing spaces
> sometimes and sometimes not.
> In case of varchar field values will appear in database sometimes with
> trailing spaces and sometimes without.
> This requires major application re-design which much is more expensive than
> continuing using char fields.

A simple BEFORE INSERT OR UPDATE trigger would take care of that.

> > You'd have to use an OpenSSL library with compression support enabled.
>
> Should I change OpenSSL installed from standard repository in Debian server
> or can it changed only for PostgreSql.
> How ?

I don't know if Debian's binaries are built with compression support,
probably not. You can build OpenSSL yourself and make PostgreSQL
use these binaries.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com