Re: AW: No result when selecting attstattarget from pg_attribute

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: AW: No result when selecting attstattarget from pg_attribute
Дата
Msg-id 328.1574954949@sss.pgh.pa.us
обсуждение исходный текст
Ответ на AW: No result when selecting attstattarget from pg_attribute  ("William Sescu (Suva)" <william.sescu@suva.ch>)
Ответы AW: AW: No result when selecting attstattarget from pg_attribute  ("William Sescu (Suva)" <william.sescu@suva.ch>)
Список pgsql-admin
Дерево обсуждения 
"William Sescu (Suva)" <william.sescu@suva.ch> 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

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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: AW: No result when selecting attstattarget from pg_attribute
Следующее
От: "William Sescu (Suva)"
Дата:
Сообщение: AW: AW: No result when selecting attstattarget from pg_attribute