Postgres Pro
Downloads
Home   >   mailing lists

Re: Connection Options -- SSL already uses compression? - Mailing list pgsql-performance

From Magnus Hagander
Subject Re: Connection Options -- SSL already uses compression?
Date
Msg-id CABUevEw5T=djMDdbc2rp41fwnCivBhZ+nEm2WsmJV3v1XoVmww@mail.gmail.com
Whole thread Raw
In response to Connection Options -- SSL already uses compression?  (Karl Denninger <karl@denninger.net>)
List pgsql-performance
Tree view 
On Sat, Oct 20, 2012 at 3:10 AM, Karl Denninger <karl@denninger.net> wrote:
> Am I reading this correctly -- it appears that if SSL negotiation is enabled
> for a connection (say, when using pg_basebackup over a WAN) that compression
> is automatically used (provided it is supported on both ends)?

That would depend on the OpenSSL defaults, I believe. Pretty sure you
can configure that system wide.


> Is there a way to check and see if it is on for a given connection?

You can use PQgetssl() and then use OpenSSL functions to get the info
from there. I'm not sure exactly how, but it would surprise me if it's
not possible.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

pgsql-performance by date:

Previous
From: Karl Denninger
Date:
Subject: Connection Options -- SSL already uses compression?
Next
From: Shaun Thomas
Date:
Subject: Tons of free RAM. Can't make it go away.