Skip site navigation (1) Skip section navigation (2)

Re: Slow query after upgrades

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: "Oliver Jowett" <oliver(at)opencloud(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Tom Duffey" <tduffey(at)techbydesign(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Slow query after upgrades
Date: 2007-12-14 00:27:23
Message-ID: 1d4e0c10712131627q7cc8cccdv4494cd6c69c0bc13@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
On Dec 14, 2007 12:54 AM, Oliver Jowett <oliver(at)opencloud(dot)com> wrote:
> The JDBC driver is using an unnamed statement in this case, shouldn't
> the planner end up using index selectivity estimates based on the actual
> parameter values?

Tom fixed that during the 8.3 development cycle IIRC but it was not
the case in 8.2 and earlier.

--
Guillaume

In response to

pgsql-jdbc by date

Next:From: Ken JohansonDate: 2007-12-14 00:48:31
Subject: Re: RETURNING clause: how to specifiy column indexes?
Previous:From: Tom DuffeyDate: 2007-12-14 00:19:03
Subject: Re: Slow query after upgrades

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group