vacuumdb: Add option for analyzing only relations missing stats. This commit adds a new --missing-stats-only option that can be used with --analyze-only or --analyze-in-stages. When this option is specified, vacuumdb will analyze a relation if it lacks any statistics for a column, expression index, or extended statistics object. This new option is primarily intended for use after pg_upgrade (since it can now retain most optimizer statistics), but it might be useful in other situations, too.
Author: Corey Huinker <corey.huin...@gmail.com> Co-authored-by: Nathan Bossart <nathandboss...@gmail.com> Reviewed-by: John Naylor <johncnaylo...@gmail.com> Discussion: https://postgr.es/m/Z5O1bpcwDrMgyrYy%40nathan Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/edba754f052ea0c02287080004aa6051eaa4f597 Modified Files -------------- doc/src/sgml/ref/vacuumdb.sgml | 16 +++++ src/bin/scripts/t/100_vacuumdb.pl | 60 ++++++++++++++++ src/bin/scripts/vacuumdb.c | 114 ++++++++++++++++++++++++++++++- src/test/perl/PostgreSQL/Test/Cluster.pm | 27 ++++++++ 4 files changed, 215 insertions(+), 2 deletions(-)
