From: | Federico Di Gregorio <federico(dot)digregorio(at)dndg(dot)it> |
---|---|
To: | psycopg(at)postgresql(dot)org |
Subject: | Re: Input and Output data traffic |
Date: | 2011-05-15 17:25:50 |
Message-ID: | 4DD00C9E.8090405@dndg.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | psycopg |
On 13/05/11 18:33, Israel Ben Guilherme Fonseca wrote:
> Well I finally figure it out (or somewhat).
>
> The "problem" is indeed the 'sslmode' parameter of the psycopg2 connection.
>
> If omitted, I think that's the default value is 'prefer' (enable ssl if
> the server support). With that I got the very low value of 29014KB for
> traffic.
>
> When i explicitly set it to 'disable', I got almost the same result of
> java 221222KB.
>
> So here's the question, does the SSL also compress the traffic data? I
> enabled the self-signed certificate mode in the Java test and got the
> same result.
Absolutely yes. Compression is considered a standard part of every
modern encription algorithm.
federico
--
Federico Di Gregorio federico(dot)digregorio(at)dndg(dot)it
Studio Associato Di Nunzio e Di Gregorio http://dndg.it
If a process is potentially good, but 90%+ of the time smart and
well-intentioned people screw it up, then it's a bad process.
-- Steve Yegge
From | Date | Subject | |
---|---|---|---|
Next Message | hatem gamal elzanaty | 2011-05-16 02:23:37 | python to postgresql crud application example needed |
Previous Message | maplabs | 2011-05-13 17:49:42 | Re: connection lost with concurrent transactions |