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
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 |