About binaryTransfer.
От | Tomonari Katsumata |
---|---|
Тема | About binaryTransfer. |
Дата | |
Msg-id | 5306F4F8.4050408@po.ntts.co.jp обсуждение исходный текст |
Ответы |
Re: About binaryTransfer.
|
Список | 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.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
В списке pgsql-jdbc по дате отправления: