• Jeff Davis's avatar
    Rework HashAgg GUCs. · 92c58fd9
    Jeff Davis authored
    Eliminate enable_groupingsets_hash_disk, which was primarily useful
    for testing grouping sets that use HashAgg and spill. Instead, hack
    the table stats to convince the planner to choose hashed aggregation
    for grouping sets that will spill to disk. Suggested by Melanie
    Plageman.
    
    Rename enable_hashagg_disk to hashagg_avoid_disk_plan, and invert the
    meaning of on/off. The new name indicates more strongly that it only
    affects the planner. Also, the word "avoid" is less definite, which
    should avoid surprises when HashAgg still needs to use the
    disk. Change suggested by Justin Pryzby, though I chose a different
    GUC name.
    
    Discussion: https://postgr.es/m/CAAKRu_aisiENMsPM2gC4oUY1hHG3yrCwY-fXUg22C6_MJUwQdA%40mail.gmail.com
    Discussion: https://postgr.es/m/20200610021544.GA14879@telsasoft.com
    Backpatch-through: 13
    92c58fd9
planner.c 246 KB