PostgreSQL: How to enable autovacuum?

postgresql database-administration vacuum autovacuum
JTW picture JTW · Oct 28, 2015 · Viewed 10.7k times · Source

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

Answer

Craig Ringer picture Craig Ringer · Oct 28, 2015

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.

Related questions

Are there any good PostgreSQL clients for linux?

I am frustrated of not having a good Linux GUI administration and development tool for PostgreSQL. pgAdmin III is buggy and unusable piece of... hmm, software, compared to Windows-only PostgreSQL Maestro and EMS PostgreSQL manager. phpPgaAmin does not looks promising. …

Read More
Cannot drop PostgreSQL role. Error: `cannot be dropped because some objects depend on it`

I was trying to delete PostgreSQL user: DROP USER ryan; I received this error: Error in query: ERROR: role "ryan" cannot be dropped because some objects depend on it DETAIL: privileges for database mydatabase I looked for a solution from …

Read More
How do I find the last time that a PostgreSQL database has been updated?

I am working with a postgreSQL database that gets updated in batches. I need to know when the last time that the database (or a table in the database)has been updated or modified, either will do. I saw that …

Read More