pgsql: Fix test races between syscache-update-pruned.spec and autovacuu

2025-04-10 Thread Noah Misch
Fix test races between syscache-update-pruned.spec and autovacuum. This spec fails ~3% of my Valgrind runs, and the spec has failed on Valgrind buildfarm member skink at a similar rate. Two problems contributed to that: - A competing buffer pin triggered VACUUM's lazy_scan_noprune() path, causin

pgsql: Fix test races between syscache-update-pruned.spec and autovacuu

2025-04-09 Thread Noah Misch
Fix test races between syscache-update-pruned.spec and autovacuum. This spec fails ~3% of my Valgrind runs, and the spec has failed on Valgrind buildfarm member skink at a similar rate. Two problems contributed to that: - A competing buffer pin triggered VACUUM's lazy_scan_noprune() path, causin