aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2002-06-23 03:45:15 +0000
committerBruce Momjian <bruce@momjian.us>2002-06-23 03:45:15 +0000
commita36711c36874c3b23c3d416bbe1844dffe331ffe (patch)
treeb1a7f4944e363a24cb49adc11dfbd211b37b49f1 /doc/src
parent30be6c23c123d367542f1cc7e1b11cd11e898366 (diff)
downloadpostgresql-a36711c36874c3b23c3d416bbe1844dffe331ffe.tar.gz
postgresql-a36711c36874c3b23c3d416bbe1844dffe331ffe.zip
Mention REINDEX can be used for disk space reclaimation too.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/reindex.sgml8
1 files changed, 7 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml
index 95830ebd420..70dbf636b61 100644
--- a/doc/src/sgml/ref/reindex.sgml
+++ b/doc/src/sgml/ref/reindex.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/reindex.sgml,v 1.11 2002/04/23 02:07:16 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/reindex.sgml,v 1.12 2002/06/23 03:45:15 momjian Exp $
PostgreSQL documentation
-->
@@ -123,6 +123,12 @@ REINDEX
</para>
<para>
+ <command>REINDEX</command> also removes certain dead index pages that
+ can't be reclaimed any other way. See the "Routine Reindexing"
+ section in the manual for more information.
+ </para>
+
+ <para>
If you suspect corruption of an index on a user table, you can
simply rebuild that index, or all indexes on the table, using
<command>REINDEX INDEX</command> or <command>REINDEX TABLE</command>.