Minimum dead tuples before autovacuum considers a table.
At a glance
| Property | Value |
|---|---|
| Parameter | autovacuum_vacuum_threshold |
| Category | Autovacuum |
| Default | 50 |
| Value type | boolean / enum / numeric |
| Change scope | Reload (no restart) |
What it does
The base number of dead tuples (added to the scale-factor term) required before autovacuum vacuums a table.
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_vacuum_threshold; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'autovacuum_vacuum_threshold';.
Tuning guidance
Keep low; the scale factor dominates on large tables. Raise the threshold only on tiny, hot tables to avoid constant vacuuming.