Search Documentation: Home → Documentation → Manuals → PostgreSQL 9.1 This page in other versions: 9.0 / 9.1 / 9.2 / 9.3 |  Development versions: devel / 9.4 |  Unsupported versions: 7.1 / 7.2 / 7.3 / 7.4 / 8.0 / 8.1 / 8.2 / 8.3 / 8.4 PostgreSQL 9.1.14 Documentation Prev Up Next VACUUM -- garbage-collect and optionally analyze a database VACUUM [ ( { FULL | FREEZE | VERBOSE | ANALYZE } [, ...] ) ] [ table [ ( column [, ...] ) ] ] VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ table ] VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ table [ ( column [, ...] ) ] ] VACUUM reclaims storage occupied by dead tuples. In normal PostgreSQL operation, tuples that are deleted or obsoleted by an update are not physically removed from their table; they remain present until a VACUUM is done. Therefore it's necessary to do VACUUM periodically, espe...