Re: regarding statistics retaining with 18 Upgrade

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: regarding statistics retaining with 18 Upgrade
Дата
Msg-id CAKAnmmJ=r_4-bdigQgv4LhUUpB=dF2Lex_4jbQtN+EZC0OdvZg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: regarding statistics retaining with 18 Upgrade  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
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

--
Enterprise Postgres Software Products & Tech Support

В списке pgsql-hackers по дате отправления: