Thread

Re: regarding statistics retaining with 18 Upgrade

Greg Sabino Mullane <htamfids@gmail.com> — 2025-11-15T16:02:23Z

On Sat, Nov 15, 2025 at 9:32 AM Bruce Momjian <bruce@momjian.us> wrote:

> Uh, it is the _optimizer_ statistics that are preserved by pg_upgrade,
>

Specifically, check out the pg_stats view. Try this on your new cluster:

select count(distinct tablename) from pg_stats where tablename !~
'pg_|sql_';

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support