Postgres Pro
Downloads
Home   >   mailing lists

Re: AW: No result when selecting attstattarget from pg_attribute - Mailing list pgsql-admin

From Tom Lane
Subject Re: AW: No result when selecting attstattarget from pg_attribute
Date
Msg-id 328.1574954949@sss.pgh.pa.us
Whole thread Raw
In response to AW: No result when selecting attstattarget from pg_attribute  ("William Sescu (Suva)" <william.sescu@suva.ch>)
Responses AW: AW: No result when selecting attstattarget from pg_attribute  ("William Sescu (Suva)" <william.sescu@suva.ch>)
List pgsql-admin
Tree view 
"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 by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: AW: No result when selecting attstattarget from pg_attribute
Next
From: "William Sescu (Suva)"
Date:
Subject: AW: AW: No result when selecting attstattarget from pg_attribute