Re: Optimizer generates bad plans.

Congratulations.  That is the largest plan I have ever seen.  ;-)

---------------------------------------------------------------------------

Kris Jurka wrote:
> While adding schema support to the JDBC Driver, I came across a query 
> which occasionally generates some spectacularly bad plans.  I have 
> attached the query and explain analyze outputs against today's cvs head 
> for queries that take between 9 and 845941 msec.  In the JDBC Driver I 
> will specify a reasonable join order using explicit JOINs, but I thought 
> someone might be interested in a test case for the optimizer.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073