diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-06-22 04:08:07 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-06-22 04:08:07 +0000 |
| commit | a8a1f158775cb0f83707aa4211c02f4780eed07f (patch) | |
| tree | c23194d08b5bac62707a5c4f428fc47b65010a43 /doc/src | |
| parent | 90edb265e396312e4a0c15d021745a944648e7ee (diff) | |
| download | postgresql-a8a1f158775cb0f83707aa4211c02f4780eed07f.tar.gz postgresql-a8a1f158775cb0f83707aa4211c02f4780eed07f.zip | |
uint -> uint32, portability.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/maintenance.sgml | 21 |
1 files changed, 20 insertions, 1 deletions
diff --git a/doc/src/sgml/maintenance.sgml b/doc/src/sgml/maintenance.sgml index b2fa6febc49..9ced267bced 100644 --- a/doc/src/sgml/maintenance.sgml +++ b/doc/src/sgml/maintenance.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/maintenance.sgml,v 1.14 2002/06/13 05:15:22 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/maintenance.sgml,v 1.15 2002/06/22 04:08:07 momjian Exp $ --> <chapter id="maintenance"> @@ -367,6 +367,25 @@ VACUUM </sect1> + <sect1 id="routine-reindex"> + <title>Routine Reindexing</title> + + <indexterm zone="routine-reindex"> + <primary>reindex</primary> + </indexterm> + + <para> + <productname>PostgreSQL</productname> is unable to reuse index pages + in some cases. The problem is that if indexed rows are deleted, those + indexes pages can only be reused by rows with similar values. In + cases where low indexed rows are deleted and newly inserted rows have + high values, disk space used by the index will grow indefinately, even + if <command>VACUUM</> is run frequently. + TO BE COMPLETED 2002-06-22 bjm + </para> + </sect1> + + <sect1 id="logfile-maintenance"> <title>Log File Maintenance</title> |