pgsql: Test that vacuum removes tuples older than OldestXmin

2025-06-25 Thread Melanie Plageman
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 t

pgsql: Test that vacuum removes tuples older than OldestXmin

2025-06-24 Thread Melanie Plageman
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 t

pgsql: Test that vacuum removes tuples older than OldestXmin

2024-07-19 Thread Melanie Plageman
Test that vacuum removes tuples older than OldestXmin If vacuum fails to prune a tuple killed before OldestXmin, it will later find that tuple dead in lazy_scan_prune() and loop infinitely. Add a test reproducing this scenario to the recovery suite which creates a table on a primary, updates the

pgsql: Test that vacuum removes tuples older than OldestXmin

2024-07-19 Thread Melanie Plageman
Test that vacuum removes tuples older than OldestXmin If vacuum fails to prune a tuple killed before OldestXmin, it will later find that tuple dead in lazy_scan_prune() and loop infinitely. Add a test reproducing this scenario to the recovery suite which creates a table on a primary, updates the

pgsql: Test that vacuum removes tuples older than OldestXmin

2024-07-19 Thread Melanie Plageman
Test that vacuum removes tuples older than OldestXmin If vacuum fails to prune a tuple killed before OldestXmin, it will later find that tuple dead in lazy_scan_prune() and loop infinitely. Add a test reproducing this scenario to the recovery suite which creates a table on a primary, updates the

pgsql: Test that vacuum removes tuples older than OldestXmin

2024-07-19 Thread Melanie Plageman
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 t

pgsql: Test that vacuum removes tuples older than OldestXmin

2024-07-19 Thread Melanie Plageman
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 t