Skip to content

Commit df80f9d

Browse files
alvherrenikolai-b
andcommitted
Document that ALTER TABLE .. TYPE removes statistics
Co-authored-by: Nikolai Berkoff <nikolai.berkoff@pm.me> Discussion: https://postgr.es/m/vCc8XnwDmlP4ZnHBQLIVxzD405BiYHVC9qZlhIF7IsfxK0gC9mZ4PUUOH0-3y6kv5p-87-3_ljqT1KvQVAnb8OoWhPU3kcqWn2ZpmxRBCQg=@pm.me
1 parent 105c1de commit df80f9d

File tree

1 file changed

+6
-0
lines changed

1 file changed

+6
-0
lines changed

doc/src/sgml/ref/alter_table.sgml

+6
Original file line numberDiff line numberDiff line change
@@ -198,6 +198,12 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
198198
clause must be provided if there is no implicit or assignment
199199
cast from old to new type.
200200
</para>
201+
202+
<para>
203+
When this form is used, the column's statistics are removed,
204+
so running <link linkend="sql-analyze"><command>ANALYZE</command></link>
205+
on the table afterwards is recommended.
206+
</para>
201207
</listitem>
202208
</varlistentry>
203209

0 commit comments

Comments
 (0)