Toggle navigation

autovacuum_naptime

Type: integer
Default: 60
Min: 1
Max: 2147483
Unit: seconds (s)
Context: sighup
Restart: false

Specifies the minimum delay between autovacuum runs on any given database. In each round the daemon examines the database and issues VACUUM and ANALYZE commands as needed for tables in that database. If this value is specified without units, it is taken as seconds. The default is one minute (1min). This parameter can only be set in the postgresql.conf file or on the server command line.

Recommendations

Decrease this to 30s or 15s if you have a large number (100's) of tables, or if you otherwise see from pg_stat_user_tables that autovacuum is not keeping up.

Comments