• Fujii Masao's avatar
    Add TRUNCATE parameter to VACUUM. · b84dbc8e
    Fujii Masao authored
    This commit adds new parameter to VACUUM command, TRUNCATE,
    which specifies that VACUUM should attempt to truncate off
    any empty pages at the end of the table and allow the disk space
    for the truncated pages to be returned to the operating system.
    
    This parameter, if specified, overrides the vacuum_truncate
    reloption. If neither the reloption nor the VACUUM option is
    used, the default is true, as before.
    
    Author: Fujii Masao
    Reviewed-by: Julien Rouhaud, Masahiko Sawada
    Discussion: https://postgr.es/m/CAD21AoD+qtrSDL=GSma4Wd3kLYLeRC0hPna-YAdkDeV4z156vg@mail.gmail.com
    b84dbc8e
vacuum.out 12 KB