PGCon2012 - Final Release
PGCon 2012
The PostgreSQL Conference
Speakers | |
---|---|
Amit Kapila |
Schedule | |
---|---|
Day | Talks - 2 - Friday - 2012-05-18 |
Room | MRT 205 |
Start time | 09:00 |
Duration | 01:00 |
Info | |
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.