Introduction to Write Ahead Logging

Talk Type: 
90 Minute Mini-Tutorial
Track: 
Performance
Technical Level: 
Beginner
License: 
Creative Commons - Attribution Only

In this talk, I'll discuss write-ahead logging, the method that PostgreSQL and other databases use to ensure consistency in the event of a crash, and how PostgreSQL uses the write-ahead log to provide advanced features such as point-in-time recovery and replication. The talk will also define terms such as "checkpoint" and "torn page" and explain how those concepts affect PostgreSQL performance and recovery.