• Tomas Vondra's avatar
    Stabilize incremental_sort tests · cea09246
    Tomas Vondra authored
    The test never did ANALYZE on the test table, so the plans depended on
    various defaults (e.g. number of groups being 200). This worked most of
    the time, but with CLOBBER_CACHE_ALWAYS the autoanalyze often managed
    to build accurate stats, changing the  plan.
    
    Fixed by increasing the size of test tables a bit, making the Sort a bit
    more expensive than Incremental Sort. The tests were constructed to test
    transitions in the Incremental Sort algorithm, and this change does not
    break that.
    
    Reviewed-by: James Coleman
    Discussion: https://postgr.es/m/CAPpHfds1waRZ=NOmueYq0sx1ZSCnt+5QJvizT8ndT2=etZEeAQ@mail.gmail.com
    cea09246
incremental_sort.sql 9.28 KB