diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2021-11-05 12:09:31 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2021-11-05 12:09:31 -0300 |
| commit | df80f9da5c6541e744eeb20eaca919c7fc189999 (patch) | |
| tree | c35c6f7d415ca5db31c32b49704335bc486bd7f7 | |
| parent | 105c1de0197473dac8ada55dc8cf773d782224cb (diff) | |
| download | postgresql-df80f9da5c6541e744eeb20eaca919c7fc189999.tar.gz postgresql-df80f9da5c6541e744eeb20eaca919c7fc189999.zip | |
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
| -rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 81291577f83..2d639a66af0 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 <link linkend="sql-analyze"><command>ANALYZE</command></link> + on the table afterwards is recommended. + </para> </listitem> </varlistentry> |