• Tom Lane's avatar
    Remove cost_hashjoin's very ancient hack to discourage (once, entirely forbid) · 9a9a143a
    Tom Lane authored
    hash joins with the estimated-larger relation on the inside.  There are
    several cases where doing that makes perfect sense, and in cases where it
    doesn't, the regular cost computation really ought to be able to figure that
    out.  Make some marginal tweaks in said computation to try to get results
    approximating reality a bit better.  Per an example from Shane Ambler.
    
    Also, fix an oversight in the original patch to add seq_page_cost: the costs
    of spilling a hash join to disk should be scaled by seq_page_cost.
    9a9a143a
costsize.c 71.9 KB