pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Albe Laurenz <laurenz.albe@wien.gv.at>
Cc: Marti Raudsepp *EXTERN* <marti@juffo.org>
Cc: Merlin Moncure *EXTERN* <mmoncure@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: SSL encryption makes bytea transfer slow
Date: Fri, 04 Nov 2011 23:32:47 +0200
Message-ID: <4EB459FF.9010601@enterprisedb.com> (raw)
In-Reply-To: <D960CB61B694CF459DCFB4B0128514C20713EBB0@exadv11.host.magwien.gv.at>
References: <D960CB61B694CF459DCFB4B0128514C2070C3E84@exadv11.host.magwien.gv.at>
	<4EABBE7D.9080201@enterprisedb.com>
	<D960CB61B694CF459DCFB4B0128514C2070C413B@exadv11.host.magwien.gv.at>
	<CAHyXU0ySH+Od7QEitDmz-E7WwmnOS6k1ZUt7XFBCeF-X4PUH1A@mail.gmail.com>
	<D960CB61B694CF459DCFB4B0128514C20713EA58@exadv11.host.magwien.gv.at>
	<CABRT9RBhWGWMvxA7v-mTxcOrZ0ngrnqy66jssKOeokgRqdXqGA@mail.gmail.com>
	<D960CB61B694CF459DCFB4B0128514C20713EBB0@exadv11.host.magwien.gv.at>

On 04.11.2011 10:43, Albe Laurenz wrote:
> Marti Raudsepp wrote:
>>> Disabling OpenSSL compression in the source (which
>>> is possible since OpenSSL 1.0.0) does not give me any performance
>>> improvement.
>>
>> If it doesn't give you any performance improvement then you haven't
>> disabled compression. Modern CPUs can easily saturate 1 GbitE with
>> AES256-encrypted connections. Compression is usually the bottleneck,
>> at 20-30 MB/s.
>
> Hmm, my knowledge of OpenSSL is so little that it is well possible that
> I did it wrong. I have attached the small patch I used; can you see
> where I went wrong?

That only works with OpenSSL 1.0.0 - did you upgrade? I thought you were 
using 0.9.7a earlier.

FWIW, it would be better to test "#ifdef SSL_OP_NO_COMPRESSION" 
directly, rather than the version number.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com



view thread (13+ messages)  latest in thread

Message-ID: <4EB459FF.9010601@enterprisedb.com>
Permalink:  ../4EB459FF.9010601@enterprisedb.com/
Also on:    postgresql.org/message-id/4EB459FF.9010601@enterprisedb.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: heikki.linnakangas@enterprisedb.com, laurenz.albe@wien.gv.at, marti@juffo.org, mmoncure@gmail.com
  Subject: Re: SSL encryption makes bytea transfer slow
  In-Reply-To: <4EB459FF.9010601@enterprisedb.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox