datatype.patch

text/x-diff

Filename: datatype.patch

Type: text/x-diff

Part: 0

Message: Re: ALTER TABLE ... SET DATA TYPE removes statistics

Patch

Format: unified

File	+	−
doc/src/sgml/ref/alter_table.sgml	6	0

diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml
index 81291577f8..86fc15c8b3 100644
--- a/doc/src/sgml/ref/alter_table.sgml
+++ b/doc/src/sgml/ref/alter_table.sgml
@@ -198,6 +198,12 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
       clause must be provided if there is no implicit or assignment
       cast from old to new type.
      </para>
+
+     <para>
+      When this form is used, the column's statistics are removed,
+      so running <command>ANALYZE</command> on the table afterwards
+      is recommended.
+     </para>
     </listitem>
    </varlistentry>