pgconfigurator
pgconfigurator

autovacuum_naptime

No restart — takes effect on reloadtime (s/min)

How long the autovacuum daemon sleeps between checking for work.

What it does

autovacuum_naptime is the pause between autovacuum's rounds of checking each database for tables that need attention. Shorter naptimes make it react faster to churn; longer ones reduce idle overhead.

How to tune it

Leave it at the 1-minute default — pgconfigurator deliberately doesn't change it. Naptime only controls how often the launcher wakes; it isn't the lever that makes vacuum run sooner. To make autovacuum react to churn, lower autovacuum_vacuum_scale_factor on hot tables instead. On a cluster with very many databases the per-database checks can add up, in which case lengthening naptime slightly reduces idle overhead.

Related parameters