Skip to content

Commit 5c3102d

Browse files
committed
Mention ANALYZE after CLUSTER.
1 parent d1c6416 commit 5c3102d

File tree

1 file changed

+8
-4
lines changed

1 file changed

+8
-4
lines changed

doc/src/sgml/ref/cluster.sgml

Lines changed: 8 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/cluster.sgml,v 1.17 2002/08/10 20:43:46 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/cluster.sgml,v 1.18 2002/08/10 21:03:33 momjian Exp $
33
PostgreSQL documentation
44
-->
55

@@ -183,9 +183,12 @@ SELECT <replaceable class="parameter">columnlist</replaceable> INTO TABLE <repla
183183
</para>
184184

185185
<para>
186-
As opposed to previous releases, CLUSTER does not lose GRANT,
187-
inheritance or foreign key information, and preserves indexes
188-
other than the one being used for the CLUSTER.
186+
CLUSTER preserves GRANT, inheritance index, and foreign key information.
187+
</para>
188+
189+
<para>
190+
Because the optimizer records the cluster status of tables, it is
191+
advised to run <command>ANALYZE</command> on the newly clustered table.
189192
</para>
190193

191194
</refsect2>
@@ -238,3 +241,4 @@ sgml-local-catalogs:"/usr/lib/sgml/catalog"
238241
sgml-local-ecat-files:nil
239242
End:
240243
-->
244+

0 commit comments

Comments
 (0)