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.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler@8232a5d,
maxRows=0, fetchSize=0, flags=16
14:09:55.878 (1) simple execute,
handler=org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler@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.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler@19cdbc83,
maxRows=0, fetchSize=0, flags=48
14:20:34.992 (1) simple execute,
handler=org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler@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