Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Optimizer generates bad plans.
Date
Msg-id 8859.1032474867@sss.pgh.pa.us
Whole thread Raw
In response to Optimizer generates bad plans.  (Kris Jurka <jurka@ejurka.com>)
Responses Re: Optimizer generates bad plans.
List pgsql-hackers
Tree view 
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?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Optimizer generates bad plans.
Next
From: Rod Taylor
Date:
Subject: Re: Optimizer generates bad plans.