PGCon2012 - Final Release

PGCon 2012
The PostgreSQL Conference

Amit Kapila
Day Talks - 2 - Friday - 2012-05-18
Room MRT 205
Start time 09:00
Duration 01:00
ID 408
Event type Lecture
Track Hacking
Language used for presentation English

WAL Internals Of PostgreSQL

Describes the Write-Ahead-Log Internals of PostgreSQL system. Improvements in WAL system that can be done to improve the performance.

PostgreSQL uses WAL files to perform Crash recovery, Point In Time Recovery and Streaming Replication. This article will cover details of WAL system in PostgreSQL like what kind os WAL record gets generated on DML operations. WAL file name details and the contents it contains. The details of Async Commit and how it protects Partial Page writes using WAL system are covered. Finally some Advantages/Disadvantages and improvements w.r.t other RDBMS that can be done in PostgreSQL WAL system to improve its performance.