]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Test that vacuum removes tuples older than OldestXmin
authorMelanie Plageman <melanieplageman@gmail.com>
Fri, 19 Jul 2024 14:40:42 +0000 (10:40 -0400)
committerMelanie Plageman <melanieplageman@gmail.com>
Fri, 19 Jul 2024 16:12:03 +0000 (12:12 -0400)
commit80c34692e8e674e3b2f150f248ef2002ae2ac3a7
treee1aa44fdd897cf47381549a442777ebb65af1ce6
parentfd4f12df5e46793a651f2d0a272f88a6cf4b358c
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
src/test/recovery/meson.build
src/test/recovery/t/043_vacuum_horizon_floor.pl [new file with mode: 0644]