Postgres Pro
Downloads
Home   >   mailing lists

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

From emergency.shower@gmail.com
Subject Severe performance degradation when using the 9.2-1000 JDBC 4 driver
Date
Msg-id CACLs3uCrjXaY94ivGQgoXDfe-2dwxwsHdPXrA3ey+eL7TPQEJA@mail.gmail.com
Whole thread Raw
Responses Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver
Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver
Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver
List pgsql-jdbc
Tree view 
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

pgsql-jdbc by date:

Previous
From: Craig Ringer
Date:
Subject: Re: bug report: slow getColumnTypeName
Next
From: Thomas Kellerer
Date:
Subject: Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver