"William Sescu (Suva)" <william.sescu@xxxxxxx> 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