PostgreSQL: How to enable autovacuum?
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.
You can start the vacuum manually also. By running psql command vacuum full analyze verbose. It will take some time.