Andrew - Supernews <[EMAIL PROTECTED]> writes:
> The cost for the Merge Left Join is clearly preposterous, since the join
> cost can't be lower than the cost of the left branch, as it is an outer
> join and therefore that branch must be run to completion. I do not fully
> understand the cost estima
This came up from a user in the IRC channel; while examining his EXPLAIN
ANALYZE output, we found some rather radical discrepancies in the costs
for a merge join, which was resulting in very suboptimal plans. I was
able to reduce his data to a test case as follows:
create table mjtest1 (id integer
