Re: SSL encryption makes bytea transfer slow - Mailing list pgsql-performance

From Albe Laurenz
Subject Re: SSL encryption makes bytea transfer slow
Date
Msg-id D960CB61B694CF459DCFB4B0128514C20713F461@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: SSL encryption makes bytea transfer slow  (Marti Raudsepp <marti@juffo.org>)
List pgsql-performance
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.

I finally managed to disable compression, and the performance
improvement is dramatic.

Now I have "only" 100% penalty for using SSL, as seen in this
oprofile report:

samples  %        image name               symbol name
751      50.1670  libcrypto.so.1.0.0       /usr/lib64/libcrypto.so.1.0.0
594      39.6794  postgres                 hex_encode
83        5.5444  libc-2.12.so             memcpy

I'll post to hackers and see if I can get this into core.

Yours,
Laurenz Albe

pgsql-performance by date:

Previous
From: Mario Weilguni
Date:
Subject: Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!
Next
From: Josh Berkus
Date:
Subject: STRICT SQL functions never inline