pgsql: Add more tests for relation statistics with rewrites

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add more tests for relation statistics with rewrites
Date: 2025-11-10 05:30:46
Message-ID: E1vIKUI-005rur-1N@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add more tests for relation statistics with rewrites

While there are many tests related to relation rewrites, nothing existed
to check how the cumulative statistics behave in such cases for
relations.

A different patch is under discussion to move the relation statistics to
be tracked on a per-relfilenode basis, so as these could be rebuilt
during crash recovery. This commit gives us a way to check (and perhaps
change) the existing behaviors for several rewrite scenarios, mixing
transactions, sub-transactions, two-phase commit and VACUUM.

Author: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
Reviewed-by: Michael Paquier <michael(at)paquier(dot)xyz>
Discussion: https://postgr.es/m/aQ3X20hbqoThQXgp@ip-10-97-1-34.eu-west-3.compute.internal

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/b23fe993e13612424faaee7ed35c4b830a2c0dfc

Modified Files
--------------
src/test/regress/expected/stats_rewrite.out | 355 ++++++++++++++++++++++++
src/test/regress/expected/stats_rewrite_1.out | 376 ++++++++++++++++++++++++++
src/test/regress/parallel_schedule | 2 +-
src/test/regress/sql/stats_rewrite.sql | 220 +++++++++++++++
4 files changed, 952 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Daniel Gustafsson 2025-11-10 11:56:54 pgsql: Fix typos in nodeWindowAgg comments
Previous Message David Rowley 2025-11-10 04:16:12 pgsql: Doc: more uppercase keywords in SQLs