This text was automatically converted from troff me macros to HTML. Information may have been lost, added, or changed in the process. Lars Aronsson and Lysator do not guarantee the correctness of this HTML document.
vacuum *- Vacuum a POSTGRES database
vacuum dbname
Vacuum vacuums a POSTGRES database. Vacuuming a database moves deleted records to an archive for archived classes, cleans out records from aborted transactions, and updates statistics that are stored in the system catalogs. Databases should be vacuumed from time to time. We recommend adding an entry to "/usr/lib/crontab" to vacuum production databases nightly.
As of release 3.0 of POSTGRES, the vacuum command is a shell script that executes the Postquel query vacuum on the database of interest. See the Postquel reference manual for details.
PGPORT The port on which the postmaster is running. This value is used if the -p option is not specified. If -p is not specified and PGPORT is not set, then the port defaults to 4321.
PGHOST The host on which the postmaster is running. This value is used if the -h option is not specified. If -h is not specified and PGHOST is not set, then the host defaults to "localhost".
vacuum(postquel).