• Michael Paquier's avatar
    Improve stability of test with vacuum_truncate in reloptions.sql · fe246d1c
    Michael Paquier authored
    This test has been using a simple VACUUM with pg_relation_size() to
    check if a relation gets physically truncated or not, but forgot the
    fact that some concurrent activity, like checkpoint buffer writes, could
    cause some pages to be skipped.  The second test enabling
    vacuum_truncate could fail, seeing a non-empty relation.  The first test
    would not have failed, but could finish by testing a behavior different
    than the one aimed for.  Both tests gain a FREEZE option, to make the
    vacuums more aggressive and prevent page skips.
    
    This is similar to the issues fixed in c2dc1a79.
    
    Author: Arseny Sher
    Reviewed-by: Masahiko Sawada
    Discussion: https://postgr.es/m/87tuotr2hh.fsf@ars-thinkpad
    backpatch-through: 12
    fe246d1c
reloptions.sql 5.29 KB