Skip to content

Glossary: PostgreSQL Beyond the Basics

Autovacuum

Also written: autovacuum, autovacuum_vacuum_scale_factor

A background process that runs VACUUM and ANALYZE on a table once enough rows have changed. The scale factor (0.2 by default) sets what share of the table counts as enough. Never turn it off.

Where the book teaches it

Related terms

VACUUMDead row, bloatFrozen, wraparound