• Michael Paquier's avatar
    Improve stability of tests for VACUUM (SKIP_LOCKED) · 3db0598d
    Michael Paquier authored
    Concurrent autovacuums running with the main regression test suite
    could cause the tests with VACUUM (SKIP_LOCKED) to generate randomly
    WARNING messages.  For these tests, set client_min_messages to ERROR to
    get rid of those random failures, as disabling autovacuum for the
    relations operated would not completely close the failure window.
    
    For isolation tests, disable autovacuum for the relations vacuumed with
    SKIP_LOCKED.  The tests are designed so as LOCK commands are taken
    in a first session before running a concurrent VACUUM (SKIP_LOCKED) in a
    second to generate WARNING messages, but a concurrent autovacuum could
    cause the tests to be slower.
    
    Reported-by: Tom Lane
    Author: Michael Paquier
    Reviewed-by: Andres Freund, Tom Lane
    Discussion: https://postgr.es/m/25294.1573077278@sss.pgh.pa.us
    Backpatch-through: 12
    3db0598d
vacuum.out 14.2 KB