Re: getImportedKeys

I don't know what is with this query
I try with 240 rows in pg_constraint and query time is almost always diferent
Sometime isn't execute (return failure for write - I have 300 mb free on disk)
I send message in hackers forum, but no answer

Prepared statement don't solution, I think that problem is lock referential
integrity table in PostgreSQL

regards
Haris Peco
On Friday 10 January 2003 11:35, Dave Cramer wrote:
> 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(at)postgresql(dot)org
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org