Re: Connection Options -- SSL already uses compression?

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Karl Denninger <karl(at)denninger(dot)net>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Connection Options -- SSL already uses compression?
Date: 2012-10-21 07:51:03
Message-ID: CABUevEw5T=djMDdbc2rp41fwnCivBhZ+nEm2WsmJV3v1XoVmww@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, Oct 20, 2012 at 3:10 AM, Karl Denninger <karl(at)denninger(dot)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/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Shaun Thomas 2012-10-22 17:35:32 Tons of free RAM. Can't make it go away.
Previous Message Karl Denninger 2012-10-20 01:10:24 Connection Options -- SSL already uses compression?