pgPedia

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Top / V

• Browse categories
• PostgreSQL releases
  • PostgreSQL 15 (dev)
  • PostgreSQL 14 (latest)
  • PostgreSQL 13
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL
Abbreviations and acronyms

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

VACUUM

VACUUM is a utility command for manually carrying out garbage collection on a database. It can be optionally combined with the ANALYZE command for collecting table statistics.

VACUUM has always present in PostgreSQL. It is a PostgreSQL extension and is not part of the SQL standard.

VACUUM and autovacuum

Since PostgreSQL 8.1, regular garbage collection and statistics collection is automatically carried out by the autovacuum process.

Monitoring VACUUM progress

Since PostgreSQL 9.6, the progress reporting view pg_stat_progress_vacuum provides a way of monitoring the status of a VACUUM operation.

Change history

• PostgreSQL 14
  • option PROCESS_TOAST added (commit 7cb3048f)
  • in VERBOSE mode, reports on index pages deleted by the current operation (commit 23763618)
• PostgreSQL 13
  • option PARALLEL added (commit 40d964ec)
• PostgreSQL 12
  • option INDEX_CLEANUP added (commit a96c41fe)
  • option SKIP_LOCKED added (commit 803b1301)
  • option TRUNCATE added (commit b84dbc8e)
• PostgreSQL 9.6
  • option DISABLE_PAGE_SKIPPING added (commit ede62e56)
• PostgreSQL 9.0
  • VACUUM FULL now performs a full table rewrite (initial commit 0a469c87)
  • parenthesized option syntax added (commit 5e66a51c)
• PostgreSQL 7.2
  • option FREEZE added (commit bc7d37a5)
  • option FULL added (initial commit 320b6db0)
• PostgreSQL 6.1
  • option ANALYZE added (commit 24d48db3)

References

Categories

See also