| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Marti Raudsepp *EXTERN*" <marti(at)juffo(dot)org> |
| Cc: | "Merlin Moncure *EXTERN*" <mmoncure(at)gmail(dot)com>, "Heikki Linnakangas *EXTERN*" <heikki(dot)linnakangas(at)enterprisedb(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: SSL encryption makes bytea transfer slow |
| Date: | 2011-11-08 13:18:18 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C20713F461@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Strange, John W | 2011-11-08 22:33:09 | Trying to understand Stats/Query planner issue |
| Previous Message | Mario Weilguni | 2011-11-08 12:49:06 | Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! |