Horton

Update guidance for running vacuumdb after pg_upgrade.

Nathan Bossart <nathan@postgresql.org>

View on postgr.es
Commit: c9d502eb68094d817fe94c2e954f6fdbb62f4d48
Author: Nathan Bossart <nathan@postgresql.org>
Date: 2025-03-18T21:32:56Z
Releases: 18.0 
Update guidance for running vacuumdb after pg_upgrade.

Now that pg_upgrade can carry over most optimizer statistics, we
should recommend using vacuumdb's new --missing-stats-only option
to only analyze relations that are missing statistics.

Reviewed-by: John Naylor <johncnaylorls@gmail.com>
Discussion: https://postgr.es/m/Z5O1bpcwDrMgyrYy%40nathan

Files

PathChange+/−
doc/src/sgml/ref/pgupgrade.sgml modified +5 −4
src/bin/pg_upgrade/check.c modified +1 −1

Documentation touched

Discussion