• Robert Haas's avatar
    Add hash partitioning. · 1aba8e65
    Robert Haas authored
    Hash partitioning is useful when you want to partition a growing data
    set evenly.  This can be useful to keep table sizes reasonable, which
    makes maintenance operations such as VACUUM faster, or to enable
    partition-wise join.
    
    At present, we still depend on constraint exclusion for partitioning
    pruning, and the shape of the partition constraints for hash
    partitioning is such that that doesn't work.  Work is underway to fix
    that, which should both improve performance and make partitioning
    pruning work with hash partitioning.
    
    Amul Sul, reviewed and tested by Dilip Kumar, Ashutosh Bapat, Yugo
    Nagata, Rajkumar Raghuwanshi, Jesper Pedersen, and by me.  A few
    final tweaks also by me.
    
    Discussion: http://postgr.es/m/CAAJ_b96fhpJAP=ALbETmeLk1Uni_GFZD938zgenhF49qgDTjaQ@mail.gmail.com
    1aba8e65
create_table.out 35.3 KB