Severe performance degradation when using the 9.2-1000 JDBC 4 driver

From: "emergency(dot)shower(at)gmail(dot)com" <emergency(dot)shower(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Severe performance degradation when using the 9.2-1000 JDBC 4 driver
Date: 2012-10-05 19:27:15
Message-ID: CACLs3uCrjXaY94ivGQgoXDfe-2dwxwsHdPXrA3ey+eL7TPQEJA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

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

Regards,
Alex

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Thomas Kellerer 2012-10-05 20:12:00 Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver
Previous Message Craig Ringer 2012-10-05 05:21:11 Re: bug report: slow getColumnTypeName