Re: slow jdbc postgres connection

[Heikki Linnakangas <heikki(at)enterprisedb(dot)com>]

Stefan Zweig wrote:
> when i execute the following query via pgAdminIII i get a result within 31ms
>
> Select version()
> result: PostgreSQL 8.1
>
> if try to execute the same query using the jdbc-interface from a java-application the same query needs horrible 4756ms.
> my jdbc driver is  8.1-409 JDBC 3
> my postgres version is 8.1.8
> my JRE-Version: 1.5.0_07

Strange. Are you sure the time is spent on executing the query, and not 
on acquiring the connection? What kind of an application is it? There's 
no application server or framework involved? Would you please add 
loglevel=1 to the URL, and post the output? Maybe that will give a clue.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com