Databases Advanced

What is Write-Ahead Log (WAL)?

A technique where changes are first written to a log before being applied to the database, ensuring crash recovery and data integrity.

Write-Ahead Logging is fundamental to database reliability. Before any data modification is written to the actual data files, it is first recorded in a sequential log. If the database crashes, it can replay the WAL to recover committed transactions and undo incomplete ones. PostgreSQL uses WAL extensively — it powers crash recovery, point-in-time recovery (PITR), streaming replication, and logical replication. WAL settings like wal_level, max_wal_size, and checkpoint_timeout directly impact performance and recovery capabilities.

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

Database Backup

The process of creating copies of database data to protect against data loss from failures, corruption, or human error.

Connection String

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

A set of four properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transactions.

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

An SQL operation that combines rows from two or more tables based on a related column between them.

The default index type in most databases that organizes data in a balanced tree structure for efficient searching, sorting, and range queries.

View All Databases Terms →