Philip Warner <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings