pgsql: Fix flakiness in the pg_visibility VM-only vacuum test by using

From: Melanie Plageman <melanieplageman(at)gmail(dot)com>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix flakiness in the pg_visibility VM-only vacuum test by using
Date: 2026-02-02 22:46:15
Message-ID: E1vn2gQ-000nih-2P@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(at)gmail(dot)com>
Author: Kirill Reshke <reshkekirill(at)gmail(dot)com>
Reviewed-by: Melanie Plageman <melanieplageman(at)gmail(dot)com>
Discussion: https://postgr.es/m/2b09fba6-6b71-497a-96ef-a6947fcc39f6%40gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/4a99ef1a0d11ed464295515635a44aad1b000691

Modified Files
--------------
contrib/pg_visibility/expected/pg_visibility.out | 2 +-
contrib/pg_visibility/sql/pg_visibility.sql | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Fujii Masao 2026-02-03 01:04:35 pgsql: psql: Add %i prompt escape to indicate hot standby status.
Previous Message Nathan Bossart 2026-02-02 21:44:04 pgsql: test_shm_mq: Set background worker names.