Postgres Pro
Downloads
Home   >   mailing lists

Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver
Date
Msg-id k4neuf$k8m$1@ger.gmane.org
Whole thread Raw
In response to Severe performance degradation when using the 9.2-1000 JDBC 4 driver  ("emergency.shower@gmail.com" <emergency.shower@gmail.com>)
List pgsql-jdbc
Tree view 
emergency.shower@gmail.com wrote on 05.10.2012 21:27:
> after the upgrade the latest PortgreSQL 9.2-1000 JDBC 4 driver, we
> discovered a severe performance degradation when connecting to 8.4,
> 9.0, 9.1, and 9.2 servers.  In a test application the
> DriverManager#getConnection(String, String, String) call constantly
> took > 4500 ms compared to < 20 ms with the previous 9.1-903 JDBC 4
> driver. This makes the driver virtually unusable in production
> environments.
>
> Client: Windows 2008 R2, Windows 7
> Server: PostgreSQL 8.4, 9.0, 9.1, 9.2 on Linux 2.6

I cannot confirm that.
I actually have the impression that it's faster (at least using "localhost", can't test a remote server right now).

pgsql-jdbc by date:

Previous
From: "emergency.shower@gmail.com"
Date:
Subject: Severe performance degradation when using the 9.2-1000 JDBC 4 driver
Next
From: Kris Jurka
Date:
Subject: Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver