Re: Optimizer generates bad plans. - Mailing list pgsql-hackers

On Thu, 19 Sep 2002, Tom Lane wrote:

> Kris Jurka <jurka@ejurka.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