Input and Output data traffic

From: Israel Ben Guilherme Fonseca <israel(dot)bgf(at)gmail(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: Input and Output data traffic
Date: 2011-05-11 00:26:56
Message-ID: BANLkTinFOvkd9=NwgpDy65ejgZxyyov1YA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Hi,

I'm doing some benchmarks for a paper in my university, and with the help of
a proxy I observed something strange.

The volume of sent data (application -> database) and the response data
(database -> application) are basically the same.

For simple inserts/updates/deletes i got a difference of about 15% between
sent and received data.

I used a ruby driver and got the same results for the same instruction.

Finally I used a Java JDBC driver (for postgres too), and the difference was
huge, it was 70% (the received data was much smaller).

Do you guys have any idea about what could be? Is it possible to the JDBC
driver is using some kind of data compression for the traffic?

Thanks in advance,

Israel

Responses

Browse psycopg by date

  From Date Subject
Next Message Federico Di Gregorio 2011-05-11 08:17:10 RELEASSE: psycopg 2.4.1
Previous Message David Sloboda 2011-05-05 02:29:09 SOLVED syntax error with connection.h and more in build