From: | Israel Ben Guilherme Fonseca <israel(dot)bgf(at)gmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Incoming/Sent traffic data |
Date: | 2011-05-13 17:12:54 |
Message-ID: | BANLkTik0pEhDveN2tadj5M=G-Mhtgm7NFg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Interesting,
I don't know about the java implementation but psycopg2 is on top of libpq,
so that's why the SSL compressing is working.
--
I didn't measure the CPU consumption of compressing/encrypting the data, but
8 times less traffic looks like a good performance boost since (I think)
network is usually the bottleneck for web systems.
Is there any plan to support it? And if not is there a place to put this as
a feature request (or is this thread automatically a feature request)?
Thanks again for all the help,
Israel
2011/5/13 Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
> Israel Ben Guilherme Fonseca <israel(dot)bgf(at)gmail(dot)com> wrote:
>
> > But here is the question, does the SSL compress the data too?
>
> It can, if that is negotiated properly:
>
> http://httpd.apache.org/docs/2.0/ssl/ssl_faq.html#comp
>
> This makes sense, because any attempt to compress binary encrypted
> data will not buy much.
>
> > I enabled the self-signed ssl mode for the java test, and It was
> > indeed encrypted, but the traffic was still "big", differently to
> > the python version.
> >
> > Any Ideas?
>
> Apparently the JDBC driver isn't attempting to negotiate
> compression. I don't know how hard that would be to change.
>
> -Kevin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-05-13 17:17:10 | Re: Incoming/Sent traffic data |
Previous Message | Kevin Grittner | 2011-05-13 16:53:24 | Re: Incoming/Sent traffic data |