summaryrefslogtreecommitdiff
path: root/doc/man/vacuum.l
diff options
context:
space:
mode:
Diffstat (limited to 'doc/man/vacuum.l')
-rw-r--r--doc/man/vacuum.l37
1 files changed, 0 insertions, 37 deletions
diff --git a/doc/man/vacuum.l b/doc/man/vacuum.l
deleted file mode 100644
index 5ee2b4fe22b..00000000000
--- a/doc/man/vacuum.l
+++ /dev/null
@@ -1,37 +0,0 @@
-.\" This is -*-nroff-*-
-.\" XXX standard disclaimer belongs here....
-.\" $Header: /cvsroot/pgsql/doc/man/Attic/vacuum.l,v 1.3 1996/10/04 14:50:18 momjian Exp $
-.TH VACUUM SQL 11/05/95 Postgres95 Postgres95
-.SH NAME
-vacuum \(em vacuum a database
-.SH SYNOPSIS
-.nf
-\fBvacuum [table]\fP
-.fi
-.SH DESCRIPTION
-.BR Vacuum
-is the Postgres vacuum cleaner. It opens every class in the database,
-moves deleted records to the archive for archived relations, cleans
-out records from aborted transactions, and updates statistics in the
-system catalogs. The statistics maintained include the number of
-tuples and number of pages stored in all classes. Running
-.BR vacuum
-periodically will increase Postgres's speed in processing user queries.
-.PP
-The open database is the one that is vacuumed.
-.PP
-We recommend that production databases be vacuumed nightly, in order
-to keep statistics relatively current. The
-.BR vacuum
-query may be executed at any time, however. In particular, after
-copying a large class into Postgres or deleting a large number of
-records, it may be a good idea to issue a
-.BR vacuum
-query. This will update the system catalogs with the results of all
-recent changes, and allow the Postgres query optimizer to make better
-choices in planning user queries.
-.PP
-The purge(l) command can be used to control the archive retention
-characteristics of a given table.
-.SH "SEE ALSO"
-purge(l).