Postgres MVCC
Bloat
Fixing bloat
To fix bloat, Postgres provides vacuuming:
- A non-standard SQL command: VACUUM.
- Scans a table (or all tables).
- Locates dead row versions and registers them in the free space map.
- VACUUM FULL: Rewrites tables to squeeze out unused space.
|