Request a Demo
Home   >   mailing lists

Re: pgsql: Update guidance for running vacuumdb after pg_upgrade. - Mailing list pgsql-hackers

From Christoph Berg
Subject Re: pgsql: Update guidance for running vacuumdb after pg_upgrade.
Date
Msg-id aAj08PiW0CX7OWY9@msg.df7cb.de
Whole thread Raw
In response to Re: pgsql: Update guidance for running vacuumdb after pg_upgrade.  (Nathan Bossart <nathandbossart@gmail.com>)
List pgsql-hackers
Tree view 
Re: Nathan Bossart
>      pg_log(PG_REPORT,
> +           "Some statistics are not transferred by pg_upgrade.\n"
>             "Once you start the new server, consider running:\n"
> +           "    %s/vacuumdb %s--all --analyze-in-stages --missing-stats-only\n"
> +           "    %s/vacuumdb %s--all --analyze-only",

I would make it "Once you start the new server, run these two commands:"
to make it explicit that both should be run, not alternatively either.

This patch addresses my concern, thanks.

Christoph

pgsql-hackers by date:

Previous
From: Christoph Berg
Date:
Subject: vacuumdb --missing-stats-only and pg_upgrade from PG13
Next
From: Nathan Bossart
Date:
Subject: Re: vacuumdb --missing-stats-only and pg_upgrade from PG13