Forcing analyze on DB after upgrading?

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Forcing analyze on DB after upgrading?
Дата
Msg-id CAOC+FBUsOAKGBdNVmr2OSiRq7nLw=5jWMRjd9C5AWT6TVLXU-A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Forcing analyze on DB after upgrading?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin
Дерево обсуждения
I just upgraded from 9.6 to 12, and am noticing some queries are slow.

I did this kind of query:

SELECT relname, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze
FROM pg_stat_all_tables
WHERE schemaname = 'myschema';

And noticed null values for everything, including last analyze date.

Does this mean the planner won't be able to optimize for these tables? Do I need to do something to prep my DB for planning after upgrade?

--

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

Предыдущее
От: Keith
Дата:
Сообщение: Re: After upgrading to PG 12, \d in psql breaks with no more c.relhasoids
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Upgrading from 9.6 to 12 and running into cast issues with pg_catalog.text()