Re: Optimizer oddness, possibly compounded in 8.1 - Mailing list pgsql-hackers

From Philip Warner
Subject Re: Optimizer oddness, possibly compounded in 8.1
Date
Msg-id 439136CE.70509@rhyme.com.au
Whole thread Raw
In response to Re: Optimizer oddness, possibly compounded in 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:

>It's something that's on the ever-growing TODO list ... I dunno if
>anyone has any near-term plans to work on it.  It'd definitely be
>nice to teach the planner to do joins-over-unions well, and then
>make inheritance just invoke that behavior instead of being a crocky
>special case.
>  
>
Sounds good; currently if you use the polymorphism of inherited tables,
and happen to cross 2 such tables, you get O(n^2) performance.






pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: strange behavior (corruption?) of large production
Next
From: Simon Riggs
Date:
Subject: Re: Spam 508