Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE ... SET DATA TYPE removes statistics - Mailing list pgsql-docs

From Michael Paquier
Subject Re: ALTER TABLE ... SET DATA TYPE removes statistics
Date
Msg-id YW5BDcUqz8kucDPr@paquier.xyz
Whole thread Raw
In response to Re: ALTER TABLE ... SET DATA TYPE removes statistics  ("Euler Taveira" <euler@eulerto.com>)
Responses Re: ALTER TABLE ... SET DATA TYPE removes statistics  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-docs
Tree view 
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
Attachment

pgsql-docs by date:

Previous
From: "Euler Taveira"
Date:
Subject: Re: vacuumdb --analyze-in-stages
Next
From: PG Doc comments form
Date:
Subject: max_sync_workers_per_subscription