• Fujii Masao's avatar
    Add vacuum_truncate reloption. · 119dcfad
    Fujii Masao authored
    vacuum_truncate controls whether vacuum tries to truncate off
    any empty pages at the end of the table. Previously vacuum always
    tried to do the truncation. However, the truncation could cause
    some problems; for example, ACCESS EXCLUSIVE lock needs to
    be taken on the table during the truncation and can cause
    the query cancellation on the standby even if hot_standby_feedback
    is true. Setting this reloption to false can be helpful to avoid
    such problems.
    
    Author: Tsunakawa Takayuki
    Reviewed-By: Julien Rouhaud, Masahiko Sawada, Michael Paquier, Kirk Jamison and Fujii Masao
    Discussion: https://postgr.es/m/CAHGQGwE5UqFqSq1=kV3QtTUtXphTdyHA-8rAj4A=Y+e4kyp3BQ@mail.gmail.com
    119dcfad
tab-complete.c 163 KB