Re: bug report: slow getColumnTypeName - Mailing list pgsql-jdbc

From Craig Ringer
Subject Re: bug report: slow getColumnTypeName
Date
Msg-id 5073FC29.5020401@ringerc.id.au
Whole thread Raw
In response to Re: bug report: slow getColumnTypeName  (Eyal Wilde <eyal.wilde@gmail.com>)
List pgsql-jdbc
On 10/09/2012 02:22 PM, Eyal Wilde wrote:

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.

It probably isn't since you've tracked down where the slowness comes from and why.

That doesn't mean it's a bug, though; I haven't checked the version history but a network access wouldn't have been added without a reason.

--
Craig Ringer

pgsql-jdbc by date:

Previous
From: BENHAMOU Mathieu
Date:
Subject: drop in performance using jdbc driver version 9
Next
From: Dave Cramer
Date:
Subject: Re: drop in performance using jdbc driver version 9