Don't lose partitioned table reltuples=0 after relhassubclass=f. ANALYZE sets relhassubclass=f when a partitioned table no longer has partitions. An ANALYZE doing that proceeded to apply the inplace update of pg_class.reltuples to the old pg_class tuple instead of the new tuple, losing that reltuples=0 change if the ANALYZE committed. Non-partitioning inheritance trees were unaffected. Back-patch to v14, where commit 375aed36ad83f0e021e9bdd3a0034c0c992c66dc introduced maintenance of partitioned table pg_class.reltuples.
Reported by Alexander Lakhin. Discussion: https://postgr.es/m/[email protected] Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/e81deeefcac2a0de06f51e82405f63935f00e2bc Modified Files -------------- src/backend/commands/analyze.c | 7 +++++- src/test/regress/expected/vacuum.out | 47 ++++++++++++++++++++++++++++++++++++ src/test/regress/sql/vacuum.sql | 29 ++++++++++++++++++++++ 3 files changed, 82 insertions(+), 1 deletion(-)
