Slow query after upgrades
От | Tom Duffey |
---|---|
Тема | Slow query after upgrades |
Дата | |
Msg-id | 3EB52707-C945-43D6-9B3F-15F3B228D6F6@techbydesign.com обсуждение исходный текст |
Ответы |
Re: Slow query after upgrades
Re: Slow query after upgrades |
Список | pgsql-jdbc |
Hi All, We recently upgraded both our PostgreSQL server version (8.1.10 to 8.2.5) and JDBC driver version (pg74.216.jdbc3, yeah, I know... to 8.2-507 JDBC4). Our application has several components and all but one are working great. Unfortunately, one of them is running much slower when I use the new JDBC driver. If I leave everything else exactly the same but roll back to the pg74.216.jdbc3 driver performance improves quite a bit. By quite a bit I mean a process that takes about 15 minutes to run with the old JDBC driver takes over an hour and a half with the new driver. I'm leaving the old JDBC driver there for now but am wondering if anyone has any ideas what I should look for to find a solution to this? I jProfiled the execution and it is indeed the JDBC query that is taking significantly more time to execute with the newer driver in place. Best Regards, Tom
В списке pgsql-jdbc по дате отправления: