Hi,
I try to reduce bandwith use with ssl and compression. I create a test with:
1. CentOS release 6.6 (Final )x86_64
a. openssl-1.0.1e-30.el6_6.4.x86_64
b. kernel-2.6.32-504.1.3.el6.x86_64
2. PostgreSQL 9.3.5
a. postgresql93-libs-9.3.5-1PGDG.rhel6.x86_64
b. postgresql93-contrib-9.3.5-1PGDG.rhel6.x86_64
c. postgresql93-9.3.5-1PGDG.rhel6.x86_64
d. postgresql93-server-9.3.5-1PGDG.rhel6.x86_64
I configure a postgresql with SSL (http://www.postgresql.org/docs/9.3/static/ssl-tcp.htm), with self-signed certificate.
All work fine for SSL, but when I try to use the compression I didn’t find any difference monitoring traffic with tcdump.
These commands has the same network load (~1.1MB)
· psql "user=USER password=PASS host=HOST dbname=postgres sslmode=require sslcompression=1" -c "SELECT lpad('', 1024*1024, 'A');"
· psql "user=USER password=PASS host=HOST dbname=postgres sslmode=require sslcompression=0" -c "SELECT lpad('', 1024*1024, 'A');"
· psql "user=USER password=PASS host=HOST dbname=postgres sslmode=disable" -c "SELECT lpad('', 1024*1024, 'A');"
Best regards,
Edoardo Innocenti
This message is for the recipients only. If you receive it in error, please notify the sender and delete it together with any attachments. For any further information, including our privacy policy please refer to http://www.savinodelbene.com/privacy/