Auto vacuum is on by default. For small databases, just do nothing and everything will work fine. To confirm, check
SHOW autovacuum;
in psql . He must report on .
Large and busy databases sometimes require tuning to make automatic start more often or focus more on busy queue tables. See the manual for more information on setting up auto vacuum.