• Tom Lane's avatar
    Optimize multi-batch hash joins when the outer relation has a nonuniform · 596efd27
    Tom Lane authored
    distribution, by creating a special fast path for the (first few) most common
    values of the outer relation.  Tuples having hashvalues matching the MCVs
    are effectively forced to be in the first batch, so that we never write
    them out to the batch temp files.
    
    Bryce Cutt and Ramon Lawrence, with some editorialization by me.
    596efd27
nodeHashjoin.c 25.5 KB