Autovacuuming the PostgreSQL Database

The PostgreSQL database requires periodic maintenance known as vacuuming.

The Autovacuum Daemon is an optional feature that automatically vacuums the PostgreSQL database. It is made up of multiple processes that reclaim storage by removing obsolete data, or tuples, from the database. The Autovacuum Daemon is enabled in the default configuration.

The default Autovacuum settings for PostgreSQL can be found in the postgresql.conf file and control when and how the Autovacuum Daemon runs.

To edit the Autovacuum settings for the PostgreSQL database, find and edit the settings stored in the postgresql.conf file. The location of the postgresql.conf file will vary depending on the operating system.

NOTE: If the settings are edited in the postgresql.conf file, the PostgreSQL database needs to be restarted.