Tom Duffey wrote:
> 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.
Identify the slow query and build a testcase for that particular query
and send it to the list?
Also, beware of counting blocking I/O time as CPU time when doing Java
profiling. Probably, the Java side is just blocking waiting on the server.
There are server-side logging options you might want to look at too.
The most likely cause is that more recent drivers ("recent" is very
relative here, I think it went in for the 8.0 driver?) use the extended
query protocol which can result in different plans for some queries.
In response to
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2007-12-13 21:27:15|
|Subject: Re: how to set a PreparedStatement column of XML type in
|Previous:||From: Tom Duffey||Date: 2007-12-13 21:15:19|
|Subject: Slow query after upgrades|