Glossary — in plain language

WAL (Write-Ahead Log)

Also called: Transaction log, xlog


In plain English

Before PostgreSQL changes your actual data files, it first writes a short note describing the change to the write-ahead log. If the server crashes, it replays those notes to recover. “Write the log first, then the data” is the rule that keeps your data safe.

Why it matters

WAL powers crash recovery, replication, and point-in-time backups. WAL settings control durability vs speed, how much disk pg_wal uses, and how standbys stay in sync.

Was this helpful?

← Browse the full glossary