]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix flakiness in the pg_visibility VM-only vacuum test by using a temporary table.
authorMelanie Plageman <melanieplageman@gmail.com>
Mon, 2 Feb 2026 22:44:37 +0000 (17:44 -0500)
committerMelanie Plageman <melanieplageman@gmail.com>
Mon, 2 Feb 2026 22:45:27 +0000 (17:45 -0500)
commit4a99ef1a0d11ed464295515635a44aad1b000691
tree3629b67982a6ea426cace6ae995091b26c820d88
parent12451d9d1f5991739540aefdec77694d59567b34
Fix flakiness in the pg_visibility VM-only vacuum test by using a temporary table.

The test relies on VACUUM being able to mark a page all-visible, but
this can fail when autovacuum in other sessions prevents the visibility
horizon from advancing. Making the test table temporary isolates its
horizon from other sessions, including catalog table vacuums, ensuring
reliable test behavior.

Reported-by: Alexander Lakhin <exclusion@gmail.com>
Author: Kirill Reshke <reshkekirill@gmail.com>
Reviewed-by: Melanie Plageman <melanieplageman@gmail.com>
Discussion: https://postgr.es/m/2b09fba6-6b71-497a-96ef-a6947fcc39f6%40gmail.com
contrib/pg_visibility/expected/pg_visibility.out
contrib/pg_visibility/sql/pg_visibility.sql