"Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca> writes:
>>> Having said that, modern versions of the planner seem to deal reasonably
>>> well with this situation as long as they're being asked to push the
>>> condition through a UNION ALL. Do you really need a UNION in that view?
> This is PG v 8.3 - do you mean "modern" compared to that?
When I was testing it yesterday it seemed that versions back to 8.2
generated acceptable plans, but the results might depend on details you
didn't show us. Try it and see.
regards, tom lane