Add more tests for relation statistics with rewrites
Michael Paquier <michael@paquier.xyz>
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.pg@gmail.com> Reviewed-by: Michael Paquier <michael@paquier.xyz> Discussion: https://postgr.es/m/aQ3X20hbqoThQXgp@ip-10-97-1-34.eu-west-3.compute.internal
Files
| Path | Change | +/− |
|---|---|---|
| src/test/regress/expected/stats_rewrite_1.out | added | +376 −0 |
| src/test/regress/expected/stats_rewrite.out | added | +355 −0 |
| src/test/regress/parallel_schedule | modified | +1 −1 |
| src/test/regress/sql/stats_rewrite.sql | added | +220 −0 |
Discussion
- relfilenode statistics 56 messages · 2024-05-25 → 2026-05-18