Glossary — in plain language

Bloat


In plain English

Bloat is wasted space inside a table or index — pages full of dead row versions and gaps that no longer hold useful data. The object is physically bigger on disk than the real data needs.

Why it matters

Bloat makes scans read more pages, wastes cache and disk, and slows everything down. Reclaiming it usually needs VACUUM (to reuse space) or VACUUM FULL / pg_repack (to actually shrink the files).

Was this helpful?

← Browse the full glossary