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

Поиск
Список
Период
Сортировка
От emergency.shower@gmail.com
Тема Severe performance degradation when using the 9.2-1000 JDBC 4 driver
Дата
Msg-id CACLs3uCrjXaY94ivGQgoXDfe-2dwxwsHdPXrA3ey+eL7TPQEJA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver  (Thomas Kellerer <spam_eater@gmx.net>)
Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver  (Kris Jurka <books@ejurka.com>)
Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver  (Sérgio Saquetim <sergiosaquetim@gmail.com>)
Список 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

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: bug report: slow getColumnTypeName
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver