diff options
| author | Bruce Momjian <bruce@momjian.us> | 2007-01-31 04:13:28 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2007-01-31 04:13:28 +0000 |
| commit | 8c14912cc1d907fc10c94c3c52b98cde21c715a5 (patch) | |
| tree | a7fa27a4dcef585cff87d4992469b40dca307055 | |
| parent | e2d68988276df0b1528e1a29e163f2024bce7829 (diff) | |
| download | postgresql-8c14912cc1d907fc10c94c3c52b98cde21c715a5.tar.gz postgresql-8c14912cc1d907fc10c94c3c52b98cde21c715a5.zip | |
Document need for periodic REINDEX in VACUUM FULL cases.
| -rw-r--r-- | doc/src/sgml/maintenance.sgml | 6 | ||||
| -rw-r--r-- | doc/src/sgml/ref/vacuum.sgml | 5 |
2 files changed, 6 insertions, 5 deletions
diff --git a/doc/src/sgml/maintenance.sgml b/doc/src/sgml/maintenance.sgml index 4b321ca31bf..764d378bb68 100644 --- a/doc/src/sgml/maintenance.sgml +++ b/doc/src/sgml/maintenance.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.64 2006/11/05 22:42:07 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.64.2.1 2007/01/31 04:13:28 momjian Exp $ --> <chapter id="maintenance"> <title>Routine Database Maintenance Tasks</title> @@ -613,9 +613,7 @@ analyze threshold = analyze base threshold + analyze scale factor * number of tu for inefficient use of space: if all but a few index keys on a page have been deleted, the page remains allocated. So a usage pattern in which all but a few keys in each range are eventually deleted will see poor use of - space. The potential for bloat is not indefinite — at worst there - will be one key per page — but it may still be worthwhile to schedule - periodic reindexing for indexes that have such usage patterns. + space. For such usage patterns, periodic reindexing is recommended. </para> <para> diff --git a/doc/src/sgml/ref/vacuum.sgml b/doc/src/sgml/ref/vacuum.sgml index cf039113f64..86bdeb9291c 100644 --- a/doc/src/sgml/ref/vacuum.sgml +++ b/doc/src/sgml/ref/vacuum.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/vacuum.sgml,v 1.43 2006/11/05 22:42:07 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/vacuum.sgml,v 1.43.2.1 2007/01/31 04:13:28 momjian Exp $ PostgreSQL documentation --> @@ -167,6 +167,9 @@ VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ <replaceable class="PARAMETER"> most of the rows in a table and would like the table to physically shrink to occupy less disk space. <command>VACUUM FULL</command> will usually shrink the table more than a plain <command>VACUUM</command> would. + The <option>FULL</option> option does not shrink indexes; a periodic + <command>REINDEX</> is still recommended. In fact, it is often faster + to drop all indexes, <command>VACUUM FULL</>, and recreate the indexes. </para> <para> |