| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | "emergency(dot)shower(at)gmail(dot)com" <emergency(dot)shower(at)gmail(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver |
| Date: | 2012-10-06 00:43:58 |
| Message-ID: | alpine.BSO.2.00.1210052042290.25941@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Fri, 5 Oct 2012, emergency(dot)shower(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2012-10-06 00:47:57 | Re: bug report: slow getColumnTypeName |
| Previous Message | Thomas Kellerer | 2012-10-05 20:12:00 | Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver |