Re: Optimizer generates bad plans.

From: Kris Jurka <books(at)ejurka(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Optimizer generates bad plans.
Date: 2002-09-19 22:52:03
Message-ID: Pine.LNX.4.33.0209191849470.15929-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 19 Sep 2002, Tom Lane wrote:

> Kris Jurka <jurka(at)ejurka(dot)com> writes:
> > While adding schema support to the JDBC Driver, I came across a query
> > which occasionally generates some spectacularly bad plans.
>
> Hm, does an ANALYZE help?
>

Yes, it does, but I don't understand why. The query is entirely against
pg_catalog tables which have had all of three tables added to them. How
can the new ANALYZE stats be significantly different than what came from
the ANALYZED template1.

Kris Jurka

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-09-19 23:45:09 Re: Optimizer generates bad plans.
Previous Message Neil Conway 2002-09-19 22:43:27 Re: Optimizer generates bad plans.