Uploaded May 2026 | Updated September 2026, 1 week ago

---

Talk by Bruce Momjian

socallinuxexpo.org/scale/23x/presentations/wonderful-world-wal

The Postgres write-ahead log, or WAL, is basically a change-log for the database.  It enables several important Postgres features:  crash recovery, point-in-time recovery, and binary and logical replication.  This talk explains what is stored in the WAL, how binary and logical replication work, and how replication slots track replication progress.