This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2023

PostgreSQL Write-Ahead Logging (WAL): The Internals of Reliability and Recovery

Date: 2023-12-15
Time: 11:50–12:40
Room: Zenit

There’s a myth that instead of the Great Wall of China, this is the real WAL that’s visible from space. Journey into the core of WAL as we break down its essential components as it optimises the equilibrium between performance and consistency. Discover the meticulous process of transaction logging, where every data alteration is precisely documented, forming the bedrock of data integrity. Navigate the intricacies of checkpoint management and how WAL gets engaged. Uncover the dynamics of crash recovery, where WAL takes the lead in choreographing the recovery process, ensuring that PostgreSQL databases gracefully rebound from unexpected disruptions.


The following slides have been made available for this session:


Hamid Akhtar