PGCon2019 - 1.0.8

PGCon 2019
The PostgreSQL Conference

Devrim Gündüz
Day Tutorials - Day 2 & Unconference: Wednesday - 2019-05-29
Room DMS 1150
Start time 13:00
Duration 03:00
ID 1347
Event type Workshop
Track Tutorial
Language used for presentation English

WAL for DBAs: Everything you want to know

PostgreSQL's WAL is one of the core points of PostgreSQL, and used in many areas: Backup, replication, etc.

In this talk, I will mention about everything about WAL that a PostgreSQL DBA must know:

  • What is WAL?
  • What does it include?
  • How to read it?
  • What about wal_level?
  • Full page writes
  • Replication and WAL
  • Backup and WAL
  • PITR and WAL
  • Other topics