• Tom Lane's avatar
    Change hash index creation so that rather than always establishing exactly · c9a1cc69
    Tom Lane authored
    two buckets at the start, we create a number of buckets appropriate for the
    estimated size of the table.  This avoids a lot of expensive bucket-split
    actions during initial index build on an already-populated table.
    
    This is one of the two core ideas of Tom Raney and Shreya Bhargava's patch
    to reduce hash index build time.  I'm committing it separately to make it
    easier for people to test the effects of this separately from the effects
    of their other core idea (pre-sorting the index entries by bucket number).
    c9a1cc69
plancat.c 27.4 KB