pgsql: Test that vacuum removes tuples older than OldestXmin

From: Melanie Plageman <melanieplageman(at)gmail(dot)com>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Test that vacuum removes tuples older than OldestXmin
Date: 2024-07-19 16:15:25
Message-ID: E1sUqGT-000Hl5-5B@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Test that vacuum removes tuples older than OldestXmin

If vacuum fails to prune a tuple killed before OldestXmin, it will
decide to freeze its xmax and later error out in pre-freeze checks.

Add a test reproducing this scenario to the recovery suite which creates
a table on a primary, updates the table to generate dead tuples for
vacuum, and then, during the vacuum, uses a replica to force
GlobalVisState->maybe_needed on the primary to move backwards and
precede the value of OldestXmin set at the beginning of vacuuming the
table.

This commit is separate from the fix in case there are test stability
issues.

Author: Melanie Plageman
Reviewed-by: Peter Geoghegan
Discussion: https://postgr.es/m/CAAKRu_apNU2MPBK96V%2BbXjTq0RiZ-%3DA4ZTaysakpx9jxbq1dbQ%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/aa607980aee08416211f003ab41aa750f5559712

Modified Files
--------------
src/test/recovery/meson.build | 1 +
src/test/recovery/t/043_vacuum_horizon_floor.pl | 268 ++++++++++++++++++++++++
2 files changed, 269 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Nathan Bossart 2024-07-19 16:55:33 pgsql: Add overflow checks to money type.
Previous Message Heikki Linnakangas 2024-07-19 07:46:44 pgsql: Move resowner from common JitContext to LLVM specific