• Alexander Korotkov's avatar
    Increase upper limit for vacuum_cleanup_index_scale_factor · 6ca33a88
    Alexander Korotkov authored
    Upper limits for vacuum_cleanup_index_scale_factor GUC and reloption
    were initially set to 100.0 in 857f9c36.  However, after further
    discussion, it appears that some users like to disable B-tree cleanup
    index scan completely (assuming there are no deleted pages).
    
    vacuum_cleanup_index_scale_factor is used barely to protect against
    stalled index statistics.  And after detailed consideration it appears
    that risk of stalled index statistics is low.  And it would be nice to
    allow advanced users setting higher values of
    vacuum_cleanup_index_scale_factor.  So, set upper limit for these
    GUC and reloption to DBL_MAX.
    
    Author: Alexander Korotkov
    Reviewed-by: Masahiko Sawada
    Discussion: https://postgr.es/m/CAC8Q8tJCb%3DgxhzcV7T6ctx7PY-Ux1oA-AsTJc6cAVNsQiYcCzA%40mail.gmail.com
    6ca33a88
nbtree.c 41.1 KB