Philip Warner <pjw@rhyme.com.au> writes:
>> (The larger point that joins of inheritance unions aren't well-planned
>> is true, but it's always been true...)
> It also seems to have a probkem with unions in views.
> Is there anything that can be done about this -- workarounds etc? Any
> plans to address it? We've got a couple of places where it's beginning
> to bite us due to growth of tables.
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.
regards, tom lane