Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Boris <boris(dot)partensky(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans
Date: 2010-10-04 00:27:45
Message-ID: 4CA91F81.4050505@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Maciek Sakrejda 2010-10-04 03:35:02 Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans
Previous Message Boris 2010-10-03 13:33:13 Upgrading JDBC driver from 7.3 to 8.4 affected execution plans