Re: AW: No result when selecting attstattarget from pg_attribute

Tom Lane <[email protected]> Thu, 28 Nov 2019 10:29:09 -0500

Newsgroups	gmane.comp.db.postgresql.admin
Message-ID	<[email protected]>

"William Sescu (Suva)" <[email protected]> writes:
> Thank you Tom for clarification. However, in regards of pg_upgrade, which does not transfer statistics, how do I know
> how to create the "CREATE STATISTICS" on the new PostgreSQL version?

You are apparently confusing the *definition* of a statistics object
with the *content*.  pg_upgrade will certainly transfer the former.
Run ANALYZE to re-fill the latter.

			regards, tom lane