AW: AW: No result when selecting attstattarget from pg_attribute

Поиск
Список
Период
Сортировка
От William Sescu (Suva)
Тема AW: AW: No result when selecting attstattarget from pg_attribute
Дата
Msg-id e05d4d7d0da3470bba344db1295d0657@suva.ch
обсуждение исходный текст
Ответ на Re: AW: No result when selecting attstattarget from pg_attribute  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Thanks. It looks like that I have mixed up there a few things.
Now it's clear.

-----Ursprüngliche Nachricht-----
Von: Tom Lane <tgl@sss.pgh.pa.us>
Gesendet: Donnerstag, 28. November 2019 16:29
An: Sescu William (SW0) <william.sescu@suva.ch>
Cc: pgsql-admin@postgresql.org
Betreff: Re: AW: No result when selecting attstattarget from pg_attribute

"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
transferthe former. 
Run ANALYZE to re-fill the latter.

regards, tom lane

________________________________

Disclaimer:

Diese Nachricht und ihr eventuell angehängte Dateien sind nur für den Adressaten bestimmt. Sie kann vertrauliche oder
gesetzlichgeschützte Daten oder Informationen beinhalten. Falls Sie diese Nachricht irrtümlich erreicht hat, bitten wir
Siehöflich, diese unter Ausschluss jeglicher Reproduktion zu löschen und die absendende Person zu benachrichtigen.
Dankefür Ihre Hilfe. 

This message and any attached files are for the sole use of the recipient named above. It may contain confidential or
legallyprotected data or information. If you have received this message in error, please delete it without making any
copieswhatsoever and notify the sender. Thank you for your assistance. 

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: AW: No result when selecting attstattarget from pg_attribute
Следующее
От: Jose Redondo
Дата:
Сообщение: Portable PGAdmin