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