I verified with wireshark that getColumnTypeName indeed do a request to the postgres server. This happens with 9.1-901 and 9.1-903 BUT NOT WITH 9.0-801!!
So, the reason for the slowness seems to be obviouse now.
it will take me some time to wrap up it into a test case. I would realy like to help, but please let me know if it's realy necessary.
On Oct 5, 2012 1:07 AM, "Eyal Wilde" <
eyal@impactsoft.co.il> wrote:
ResultSetMetaData __md = __rs.getMetaData(); //this is fine
String __sf1name = __md.getColumnName(1); //this is fine
int __if1type = __md.getColumnType(1); //this is fine
String __sf1type = __md.getColumnTypeName(1); //this is SLOW!! ~15msec
postgres server version is 9.1.5
jdbc version, i checked both 9.1-901 and 9.1-903
and... BTW, 9.0-801 works good (while connected pg9.1)!