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 14 (dev)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5
  • PostgreSQL 9.4 (EOL)

Useful articles

System catalog tables
System catalog views
System statistics views
Progress reporting views

Contrib modules
Storage parameters (relopts)

xlog renaming in Pg 10

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

explain.depesz.com/

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 been present in every PostgreSQL version. It is not part of the SQL standard.

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

Change history

work-in-progress

• 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)

References

Categories

See also