Search code examples
postgresqldatabase-administrationvacuumautovacuum

PostgreSQL: How to enable autovacuum?


How does one enable autovacuum in PostgreSQL? I understand the purpose, I just can't find a simple answer regarding how to enable it.


Solution

  • Autovacuum is on by default. For small databases just do nothing and everything will work fine. To confirm, check

    SHOW autovacuum;
    

    in psql. It should report on.

    Large and busy databases sometimes require tuning to make autovacuum run more often, or focus more on busy queue tables. See the manual for details on tuning autovacuum.