From a8a1f158775cb0f83707aa4211c02f4780eed07f Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 22 Jun 2002 04:08:07 +0000 Subject: uint -> uint32, portability. --- doc/src/sgml/maintenance.sgml | 21 ++++++++++++++++++++- 1 file changed, 20 insertions(+), 1 deletion(-) (limited to 'doc/src') 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 @@ @@ -367,6 +367,25 @@ VACUUM + + Routine Reindexing + + + reindex + + + + PostgreSQL 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 VACUUM is run frequently. + TO BE COMPLETED 2002-06-22 bjm + + + + Log File Maintenance -- cgit v1.2.3