From a03c0d93d5a2730f25a3b2738300dacd8ca5e24a Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 30 Dec 2002 18:42:17 +0000 Subject: Code review for CLUSTER ALL patch. Fix bogus locking, incorrect transaction stop/start nesting, other infelicities. --- doc/src/sgml/ref/cluster.sgml | 24 +++++++++++++----------- 1 file changed, 13 insertions(+), 11 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/cluster.sgml b/doc/src/sgml/ref/cluster.sgml index e72a8f61d1f..95daa8bf176 100644 --- a/doc/src/sgml/ref/cluster.sgml +++ b/doc/src/sgml/ref/cluster.sgml @@ -1,5 +1,5 @@ @@ -108,14 +108,16 @@ CLUSTER When a table is clustered, PostgreSQL - remembers on which index it was clustered. In calls to + remembers on which index it was clustered. The form CLUSTER tablename, - the table is clustered on the same index that it was clustered before. + re-clusters the table on the same index that it was clustered before. - A simple CLUSTER clusters all the tables in the database - that the calling user owns and uses the saved cluster information. This + CLUSTER without any parameter re-clusters all the tables + in the + current database that the calling user owns, or all tables if called + by a superuser. (Never-clustered tables are not touched.) This form of CLUSTER cannot be called from inside a transaction or function. @@ -157,15 +159,15 @@ CLUSTER - CLUSTER preserves GRANT, inheritance, index, foreign - key, and other ancillary information about the table. + CLUSTER preserves GRANT, inheritance, index, foreign + key, and other ancillary information about the table. - Because CLUSTER remembers the clustering information, - one can cluster the tables one wants clustered manually the first time, and - setup a timed event similar to VACUUM so that the tables - are periodically and automatically clustered. + Because CLUSTER remembers the clustering information, + one can cluster the tables one wants clustered manually the first time, and + setup a timed event similar to VACUUM so that the tables + are periodically re-clustered. -- cgit v1.2.3