SSL Compression doesn't work

From: Edoardo Innocenti - SDB Information Technology Srl <edoardo(dot)innocenti(at)tech(dot)sdb(dot)it>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: SSL Compression doesn't work
Date: 2015-01-02 15:39:34
Message-ID: DBXPR04MB397C0BC6A009263884AD3FFA35D0@DBXPR04MB397.eurprd04.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Magnus Hagander 2015-01-02 15:48:22 Re: SSL Compression doesn't work
Previous Message Craig Ringer 2015-01-02 10:56:47 Re: PostgreSQL file system based restore from Linux to Windows