From 5c3102d6d1fe85c68759480e88703d49780e1783 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 10 Aug 2002 21:03:33 +0000 Subject: [PATCH] Mention ANALYZE after CLUSTER. --- doc/src/sgml/ref/cluster.sgml | 12 ++++++++---- 1 file changed, 8 insertions(+), 4 deletions(-) diff --git a/doc/src/sgml/ref/cluster.sgml b/doc/src/sgml/ref/cluster.sgml index 4600e9e7b9..73c188392f 100644 --- a/doc/src/sgml/ref/cluster.sgml +++ b/doc/src/sgml/ref/cluster.sgml @@ -1,5 +1,5 @@ @@ -183,9 +183,12 @@ SELECT columnlist INTO TABLE - As opposed to previous releases, CLUSTER does not lose GRANT, - inheritance or foreign key information, and preserves indexes - other than the one being used for the CLUSTER. + CLUSTER preserves GRANT, inheritance index, and foreign key information. + + + + Because the optimizer records the cluster status of tables, it is + advised to run ANALYZE on the newly clustered table. @@ -238,3 +241,4 @@ sgml-local-catalogs:"/usr/lib/sgml/catalog" sgml-local-ecat-files:nil End: --> + -- 2.40.0