Skip to main content
Skip table of contents

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.