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

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

A middleware server that sits between applications and databases, providing connection pooling, load balancing, and query routing.

A version-controlled change to a database schema that can be applied and reversed systematically.

The process of copying and maintaining database data across multiple servers for redundancy, failover, and read scaling.

An advanced open-source relational database known for its reliability, feature richness, and standards compliance.

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 →