Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans
Date
Msg-id 4CA91F81.4050505@opencloud.com
Whole thread Raw
In response to Upgrading JDBC driver from 7.3 to 8.4 affected execution plans  (Boris <boris.partensky@gmail.com>)
Responses Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans
List pgsql-jdbc
Boris wrote:

>  Another interesting point is that, when I paste the slow query into
> psql, and explain/analyze it,  bad plan is chosen (like observed from
> the code with new driver).
>
> Any ideas? I'd be happy to provide more details if needed. Is the
> issue somehow caused by the fact that 8.4 driver uses real server side
> prepared statements vs the old one that didn't?

If you get the same problem via psql, I doubt it's related to your
driver changes. What changed on the server side?

-O

pgsql-jdbc by date:

Previous
From: Boris
Date:
Subject: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans
Next
From: Maciek Sakrejda
Date:
Subject: Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans