Databases Advanced

What is Vacuum?

A PostgreSQL maintenance operation that reclaims storage from dead tuples and updates statistics for the query planner.

PostgreSQL's MVCC creates dead tuples when rows are updated or deleted. VACUUM marks this space for reuse (but does not return it to the OS). VACUUM FULL rewrites the entire table, recovering disk space but requiring an exclusive lock.

Autovacuum runs automatically based on configurable thresholds. ANALYZE updates statistics used by the query planner. Proper vacuum configuration is critical for maintaining database performance and preventing table bloat.

Learn More About This Topic

SQL for Absolute Beginners

Related reading

Redis Fundamentals

Related reading

MongoDB Fundamentals: Building Scalable NoSQL Applications with Document Databases

Related reading

Related Terms

A category of databases that store data in non-tabular formats, optimized for specific data models and access patterns.

Connection String

A formatted string containing all parameters needed to establish a connection to a database server.

A database that uses graph structures with nodes, edges, and properties to store and query highly connected data.

PostgreSQL's binary JSON data type that stores JSON documents with indexing, querying, and manipulation capabilities.

The process of organizing database tables to reduce data redundancy and improve data integrity.

Database Connection Pooling

A technique that maintains a cache of database connections for reuse, reducing the overhead of creating new connections.

View All Databases Terms →