This is useful information! Just off the top of my head, postgres uses a
genetic algorithm to evaluate the query plan, it is only invoked after
the query reaches a certain complexity. I wonder if this is the problem?
Also thinking out loud, this may be a perfect place for a server side
prepared statement, Kris ?
Dave
On Fri, 2003-01-10 at 07:32, snpe wrote:
> This isn't JDBC problem.This query work in plsql strange - one is quick, then
> slow ...
> You must >200 rows in pg_constraint for test
>
> regards
> Haris PecoOn Friday 10 January 2003 10:24, Dave Cramer wrote:
> > Martin,
> >
> > Can you send us a test case?
> >
> > Dave
> >
> > On Fri, 2003-01-10 at 05:02, Martin Keller wrote:
> > > Hi,
> > >
> > > I have a problem executing getImportedKeys. Sometimes it takes minutes
> > > to execute, sometimes it only needs a few millisconds ( with the same
> > > parameters !!!). Does anyony have a fix or workaround for this problem?
> > >
> > > Regards
> > > Martin
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Dave Cramer <Dave@micro-automation.net>