Re: Input and Output data traffic

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

In response to

Browse psycopg by date

  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