Further adjust guidance for running vacuumdb after pg_upgrade.
authorNathan Bossart <nathan@postgresql.org>
Wed, 30 Apr 2025 19:12:59 +0000 (14:12 -0500)
committerNathan Bossart <nathan@postgresql.org>
Wed, 30 Apr 2025 19:12:59 +0000 (14:12 -0500)
commitd5f1b6a75ba3f55a78959c957c3fd25d9569057c
tree6480ed74f2bc1368c1cb0d23718f1d5188c81d21
parentf60420cff66a9089a9b431f9c07f4a29aae4990a
Further adjust guidance for running vacuumdb after pg_upgrade.

Since pg_upgrade does not transfer the cumulative statistics used
to trigger autovacuum and autoanalyze, the server may take much
longer than expected to process them post-upgrade.  Currently, we
recommend analyzing only relations for which optimizer statistics
were not transferred by using the --analyze-in-stages and
--missing-stats-only options.  This commit appends another
recommendation to analyze all relations to update the relevant
cumulative statistics by using the --analyze-only option.  This is
similar to the recommendation for pg_stat_reset().

Reported-by: Christoph Berg <myon@debian.org>
Reviewed-by: Christoph Berg <myon@debian.org>
Discussion: https://postgr.es/m/aAfxfKC82B9NvJDj%40msg.df7cb.de
doc/src/sgml/ref/pgupgrade.sgml
src/bin/pg_upgrade/check.c