public inbox for [email protected]
help / color / mirror / Atom feedFrom: Melanie Plageman <[email protected]>
To: [email protected]
Subject: pgsql: Fix flakiness in the pg_visibility VM-only vacuum test by using
Date: Mon, 02 Feb 2026 22:46:15 +0000
Message-ID: <[email protected]> (raw)
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 <[email protected]>
Author: Kirill Reshke <[email protected]>
Reviewed-by: Melanie Plageman <[email protected]>
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(-)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pgsql: Fix flakiness in the pg_visibility VM-only vacuum test by using
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox