Re: Optimizer generates bad plans.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kris Jurka <jurka(at)ejurka(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Optimizer generates bad plans.
Date: 2002-09-19 22:34:27
Message-ID: 8859.1032474867@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2002-09-19 22:40:17 Re: Optimizer generates bad plans.
Previous Message Kris Jurka 2002-09-19 22:31:57 Re: Optimizer generates bad plans.