Horton

Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION

Yugo Nagata <nagata@sraoss.co.jp>

View thread View on postgr.es
From: Yugo Nagata <nagata@sraoss.co.jp>
To: Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2025-08-04T06:14:18Z
Lists: pgsql-hackers

Attachments

Hi,

The documentation recommends running ANALYZE after the "ALTER TABLE ... SET DATA TYPE"
command since the statistics will become wrong after that.

That same thing can be applied to "ALTER TABLE ... SET EXPRESSION" commands,
but that is not described in the documentation, so I've attached a patch
to add this statement.


Regards,
Yugo Nagata

Commits

  1. doc: Recommend ANALYZE after ALTER TABLE ... SET EXPRESSION AS.