pgsql: Improve the regression tests of VACUUM (PROCESS_TOAST)

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Improve the regression tests of VACUUM (PROCESS_TOAST)
Date: 2023-03-06 06:41:27
Message-ID: E1pZ4XG-0029NV-U0@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2023-03-06 07:42:11 pgsql: Add PROCESS_MAIN to VACUUM
Previous Message Amit Kapila 2023-03-06 04:50:03 pgsql: Deduplicate handling of binary and text modes in logicalrep_read