Date: Tue, 19 Oct 2021 12:52:45 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Euler Taveira <euler@eulerto.com>
Cc: "nikolai.berkoff" <nikolai.berkoff@pm.me>,
	"pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Subject: Re: ALTER TABLE ... SET DATA TYPE removes statistics
Message-ID: <YW5BDcUqz8kucDPr@paquier.xyz>
References: 
 <vCc8XnwDmlP4ZnHBQLIVxzD405BiYHVC9qZlhIF7IsfxK0gC9mZ4PUUOH0-3y6kv5p-87-3_ljqT1KvQVAnb8OoWhPU3kcqWn2ZpmxRBCQg=@pm.me>
 <99443f30-4c03-40e5-b403-055e1f3e706d@www.fastmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="IJbOhn5aoWaypdQd"
Content-Disposition: inline
In-Reply-To: <99443f30-4c03-40e5-b403-055e1f3e706d@www.fastmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/YW5BDcUqz8kucDPr%40paquier.xyz>
Precedence: bulk


--IJbOhn5aoWaypdQd
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

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

--IJbOhn5aoWaypdQd
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmFuQQ0ACgkQnvQgOdby
QH0tjRAAoeXTt9NZSOyB6FBfXoWb0F2OT7qlk2kpgg20V+qpWulqoCSF8Kd03Ww/
iIwLgrDRNVLGAq3mJbKztyS3AWTPB5LCy9ssDF7kzF1vFZpFBqZmUmoOS2GwLUSi
s2KZvS+hJbTXkVI02lx+2fUvm2Pmwatw0EDaXLchi3qMS56D6xbWVuCNybqCiChp
KhFLwq8IkRym4xwbl5tnaSTlTn0cKnebEMNcZamd8vT0W4+2GRevDCnLTaAqqkbd
66MFg3GriMdpqOO05zdIP4KqwJ3/y2jksIakgjS+khJH++NWzWQB+w2vLaA+gh7h
nA6JnvpFxts253pXnbpvGuRsz4QI5LVQa3tnz0zyS5z1uzMlcptx4HpBdp8rMxAN
iv629T4hsSJZwWPU7St7zkHAOzjAv0ylNI9eQr4ZJ+9HUJMTAQQaiG85Uxet2hH1
DaCIte9RDrj+uPPEKpi801RKzKrSaqXH5fv4M7HntttRbvUQ1Lzt4exoMQYPdfdN
T9v0lgttdgZ/DdTZlvPcrU1qApPIonDdljLAOMuLPPHHOihlraQ0ITaynhEUy6ty
BcDTGncoa6nWG4cZcimsj/YXWgbemG5QcD5acrW7zgH3uYZDJGl5TGzm2GLTmx9D
pg3Ya/reLYJFZD8V8Yz0m5gNXbv7bc+4JZO/2lBigomEczKrt8M=
=sVip
-----END PGP SIGNATURE-----

--IJbOhn5aoWaypdQd--