Commit0867493

committed

Document need for periodic REINDEX in VACUUM FULL cases.

1 parent1a62813 commit0867493Copy full SHA for 0867493

File tree

-5

lines changed

-5

lines changed

Lines changed: 2 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.66 2007/01/16 18:26:02 alvherre Exp $ -->`
	`1`	`+<!-- $PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.67 2007/01/31 04:13:22 momjian Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter id="maintenance">`
`4`	`4`	`<title>Routine Database Maintenance Tasks</title>`
`@@ -615,9 +615,7 @@ analyze threshold = analyze base threshold + analyze scale factor * number of tu`
`615`	`615`	`for inefficient use of space: if all but a few index keys on a page have`
`616`	`616`	`been deleted, the page remains allocated. So a usage pattern in which all`
`617`	`617`	`but a few keys in each range are eventually deleted will see poor use of`
`618`		`- space. The potential for bloat is not indefinite — at worst there`
`619`		`- will be one key per page — but it may still be worthwhile to schedule`
`620`		`- periodic reindexing for indexes that have such usage patterns.`
	`618`	`+ space. For such usage patterns, periodic reindexing is recommended.`
`621`	`619`	`</para>`
`622`	`620`
`623`	`621`	`<para>`

Lines changed: 4 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/ref/vacuum.sgml,v 1.45 2006/12/27 14:55:17 momjian Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/ref/vacuum.sgml,v 1.46 2007/01/31 04:13:22 momjian Exp $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -167,6 +167,9 @@ VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ <replaceable class="PARAMETER">`
`167`	`167`	`most of the rows in a table and would like the table to physically shrink`
`168`	`168`	`to occupy less disk space. <command>VACUUM FULL</command> will usually`
`169`	`169`	`shrink the table more than a plain <command>VACUUM</command> would.`
	`170`	`+ The <option>FULL</option> option does not shrink indexes; a periodic`
	`171`	`+ <command>REINDEX</> is still recommended. In fact, it is often faster`
	`172`	`+ to drop all indexes, <command>VACUUM FULL</>, and recreate the indexes.`
`170`	`173`	`</para>`
`171`	`174`
`172`	`175`	`<para>`

Comments

(0)