Re: Disable OpenSSL compression

Jeroen Vermeulen <jtv@xs4all.nl>

From: Jeroen Vermeulen <jtv@xs4all.nl>
To: Albe Laurenz <laurenz.albe@wien.gv.at>
Cc: Tom Lane *EXTERN* <tgl@sss.pgh.pa.us>, Marko Kreen <markokr@gmail.com>, pgsql-hackers@postgresql.org
Date: 2011-11-08T17:20:29Z
Lists: pgsql-hackers
On 2011-11-08 22:59, Albe Laurenz wrote:

> In addition to the oprofile data I collected three times:
> - the duration as shown in the server log
> - the duration as shown by \timing
> - the duration of the psql command as measured by "time"

[...]

> I think this makes a good case for disabling compression.

It's a few data points, but is it enough to make a good case?  As I 
understand it, compression can save time not only on transport but also 
on the amount of data that needs to go through encryption -- probably 
depending on choice of cypher, hardware support, machine word width, 
compilation details etc.  Would it make sense to run a wider experiment, 
e.g. in the buld farm?

Another reason why I believe compression is often used with encryption 
is to maximize information content per byte of data: harder to guess, 
harder to crack.  Would that matter?


Jeroen