About binaryTransfer.

From: Tomonari Katsumata <katsumata(dot)tomonari(at)po(dot)ntts(dot)co(dot)jp>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: About binaryTransfer.
Date: 2014-02-21 06:40:56
Message-ID: 5306F4F8.4050408@po.ntts.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I have a peformance trouble with 9.3-1100 driver.
Running same application(*) with 9.2-1004 and 9.3-1100,
It does another behavior.
(*) Retrieving 9990 rows with preparedStatement.

9.2-1004:
Always flags = 16.
----
14:09:55.730 (1) simple execute,
handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)8232a5d,
maxRows=0, fetchSize=0, flags=16
14:09:55.878 (1) simple execute,
handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)34e671de,
maxRows=0, fetchSize=0, flags=16
----

9.3-1100
Repeatedly flags = 48 and 16.
The count of "flags=16" is same with 9.2-1004, so
"flags=48" is extra executing.
----
14:20:34.991 (1) simple execute,
handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)19cdbc83,
maxRows=0, fetchSize=0, flags=48
14:20:34.992 (1) simple execute,
handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)304b0cbc,
maxRows=0, fetchSize=0, flags=16
----

This change has caused by below commit.
https://github.com/pgjdbc/pgjdbc/commit/dbf76c2d662896c5703cf20d7362e1d061e1e43f

It seems that binarytransfer mode is good at dealing with
big-data(many columns?many rows?), but some packets are
sent/received for this function, right?

I want to make 9.3-1100 driver do old behavior like 9.2-1004.
What can I do ?

regards,
----------------
Tomonari Katsumata

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Mikko Tiihonen 2014-02-21 07:50:26 Re: About binaryTransfer.
Previous Message Dave Cramer 2014-02-20 11:27:22 New release JDBC 9.3 1101 released