Configuration parameter

autovacuum_naptime — PostgreSQL Configuration Parameter

Category Autovacuum Default 1min Unit time (ms/s/min) Change scope Reload (no restart)

Delay between autovacuum runs per database.

At a glance

Property Value
Parameter autovacuum_naptime
Category Autovacuum
Default 1min
Value type time (ms/s/min)
Change scope Reload (no restart)

What it does

Minimum delay between autovacuum launcher cycles for a given database.

How to apply a change

Takes effect on configuration reload (sighup context). Run SELECT pg_reload_conf(); or send SIGHUP — no restart needed.

Inspect the current value and source with SHOW autovacuum_naptime; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'autovacuum_naptime';.

Tuning guidance

Lower (e.g. 15-30s) on high-churn systems so dead tuples are cleaned sooner; the default suits most.

Reference

PostgreSQL documentation — Autovacuum configuration.

Was this helpful?

← All configuration parameters