From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "Heikki Linnakangas *EXTERN*" <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
Cc: | "Marti Raudsepp *EXTERN*" <marti(at)juffo(dot)org>, "Merlin Moncure *EXTERN*" <mmoncure(at)gmail(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: SSL encryption makes bytea transfer slow |
Date: | 2011-11-08 10:25:29 |
Message-ID: | D960CB61B694CF459DCFB4B0128514C20713F324@exadv11.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Heikki Linnakangas 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.
Yes, I ran these tests with RHEL6 and OpenSSL 1.0.0.
I guess I have hit the wall here.
I can't get oprofile to run on this RHEL6 box, it doesn't record
anything, so all I can test is total query duration.
I tried to disable compression as above, but cannot verify that
I was successful.
I also tried different ciphers, but no matter what I did, the
duration on the server stayed pretty much the same, 4 to 5 times
more than without SSL.
Thanks everybody for the help.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Lucas Mocellin | 2011-11-08 10:34:10 | Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! |
Previous Message | Samuel Gendler | 2011-11-08 07:49:15 | Re: Error while vacuuming |