Re: AW: No result when selecting attstattarget from pg_attribute

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "William Sescu (Suva)" <william(dot)sescu(at)suva(dot)ch>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: AW: No result when selecting attstattarget from pg_attribute
Date: 2019-11-28 15:29:09
Message-ID: 328.1574954949@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"William Sescu (Suva)" <william(dot)sescu(at)suva(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message William Sescu (Suva) 2019-11-28 15:40:29 AW: AW: No result when selecting attstattarget from pg_attribute
Previous Message Laurenz Albe 2019-11-28 15:23:33 Re: AW: No result when selecting attstattarget from pg_attribute