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

From: Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Doc: Add note for running ANALYZE after ALTER TABLE ... SET EXPRESSION
Date: 2025-08-04 06:14:18
Message-ID: 20250804151418.0cf365bd2855d606763443fe@sraoss.co.jp
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
fix_doc_alter_table_set_expression.patch text/x-diff 705 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message shveta malik 2025-08-04 06:15:56 Re: Conflict detection for update_deleted in logical replication
Previous Message Amit Kapila 2025-08-04 06:00:49 Re: Improve pg_sync_replication_slots() to wait for primary to advance