Improve the regression tests of VACUUM (PROCESS_TOAST) All the regression tests of VACUUM (PROCESS_TOAST) were only checking if the commands were able to run, without checking if VACUUM was really running on what it should. This expands this set of tests so as we now look at pg_stat_all_tables.vacuum_count to see how many vacuums have been run on a given table and its toast relation.
Extracted from a larger patch by the same author, as this is useful on its own. Special thanks to Álvaro Herrera for the idea of using pg_stat_all_tables to check the state of the toast relation. Author: Nathan Bossart Reviewed-by: Masahiko Sawada Discussion: https://postgr.es/m/20221230000028.GA435655@nathanxps13 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/46d490ac19a7ca93a5c0f47e5a0e759b5385a8ae Modified Files -------------- src/test/regress/expected/vacuum.out | 36 ++++++++++++++++++++++++++++++++---- src/test/regress/sql/vacuum.sql | 24 ++++++++++++++++++++---- 2 files changed, 52 insertions(+), 8 deletions(-)