Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION - Mailing list pgsql-hackers

From Yugo Nagata
Subject Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION
Date
Msg-id 20250804151418.0cf365bd2855d606763443fe@sraoss.co.jp
Whole thread Raw
Responses Re: Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION
List pgsql-hackers
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

Attachment

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Improve pg_sync_replication_slots() to wait for primary to advance
Next
From: shveta malik
Date:
Subject: Re: Conflict detection for update_deleted in logical replication