From: Michael Paquier <michael@paquier.xyz>
To: Euler Taveira <euler@eulerto.com>
Cc: nikolai.berkoff <nikolai.berkoff@pm.me>
Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Subject: Re: ALTER TABLE ... SET DATA TYPE removes statistics
Date: Tue, 19 Oct 2021 12:52:45 +0900
Message-ID: <YW5BDcUqz8kucDPr@paquier.xyz> (raw)
In-Reply-To: <99443f30-4c03-40e5-b403-055e1f3e706d@www.fastmail.com>
References: <vCc8XnwDmlP4ZnHBQLIVxzD405BiYHVC9qZlhIF7IsfxK0gC9mZ4PUUOH0-3y6kv5p-87-3_ljqT1KvQVAnb8OoWhPU3kcqWn2ZpmxRBCQg=@pm.me>
<99443f30-4c03-40e5-b403-055e1f3e706d@www.fastmail.com>
On Mon, Oct 18, 2021 at 05:15:59PM -0300, Euler Taveira wrote:
> I agree that it might surprise an user and it would be good to document it.
> However, it does not belong to the description. I would add it to the Notes
> section at the end of the ALTER TABLE page.
No objections to the suggested addition and the location of the
addition (paragraph of SET DATA TYPE rather than "Notes"), but I think
that the phrasing could be better:
"The column's statistics are removed, hence a follow-up ANALYZE is
suited to update the statistics to the new column type."
--
Michael
Attachments:
[application/pgp-signature] signature.asc (832B, ../YW5BDcUqz8kucDPr@paquier.xyz/2-signature.asc)
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-docs@postgresql.org
Cc: michael@paquier.xyz, euler@eulerto.com, nikolai.berkoff@pm.me, pgsql-docs@lists.postgresql.org
Subject: Re: ALTER TABLE ... SET DATA TYPE removes statistics
In-Reply-To: <YW5BDcUqz8kucDPr@paquier.xyz>
* 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