From: William Sescu (Suva) <william.sescu@suva.ch>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: AW: AW: No result when selecting attstattarget from pg_attribute
Date: Thu, 28 Nov 2019 15:40:29 +0000
Message-ID: <e05d4d7d0da3470bba344db1295d0657@suva.ch> (raw)
In-Reply-To: <328.1574954949@sss.pgh.pa.us>
References: <4078c426dbbb4e18a047ec00485adba9@suva.ch>
<31263.1574952854@sss.pgh.pa.us>
<9545ee300c12457f8ef09c8708d45f31@suva.ch>
<328.1574954949@sss.pgh.pa.us>
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 transfer the 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 gesetzlich geschützte Daten oder Informationen beinhalten. Falls Sie diese Nachricht irrtümlich erreicht hat, bitten wir Sie höflich, diese unter Ausschluss jeglicher Reproduktion zu löschen und die absendende Person zu benachrichtigen. Danke für Ihre Hilfe.
This message and any attached files are for the sole use of the recipient named above. It may contain confidential or legally protected data or information. If you have received this message in error, please delete it without making any copies whatsoever and notify the sender. Thank you for your assistance.
Attachments:
smime.p7s (application/pkcs7-signature, 5.3K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: william.sescu@suva.ch, tgl@sss.pgh.pa.us
Subject: Re: AW: AW: No result when selecting attstattarget from pg_attribute
In-Reply-To: <e05d4d7d0da3470bba344db1295d0657@suva.ch>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox