• Tom Lane's avatar
    Tweak hash join code to use an additional heuristic for deciding whether · 4ab76b1c
    Tom Lane authored
    it's worth probing the outer relation for emptiness before building the
    hash table.  To wit, if we're rescanning a join previously performed,
    remember whether we found it nonempty the previous time, and don't bother
    with the probe if it was nonempty.  This buys back the performance lost
    in examples like Mario Weilguni's.
    4ab76b1c
execnodes.h 43 KB