On Fri, 5 Oct 2012, emergency.shower@gmail.com wrote:
> 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.
Can you show us the connection URL that you are using? Are you using SSL?
It appears that some of the 9.2 changes may require a DNS lookup that they
didn't before and you might be getting a timeout there. Any DNS issues on
your side?
Kris Jurka