PGCon2019 - 3.4

PGCon 2019
The PostgreSQL Conference

Thomas Munro
Day Talks - Day 1 - 2019-05-30
Room DMS 1110
Start time 11:00
Duration 00:45
ID 1367
Event type Lecture
Track Hacking
Language used for presentation English


In PostgreSQL and other animals

A look at PostgreSQL transaction logging in historical POSTGRES and how it evolved in modern PostgreSQL, how the approach compares to other systems, and how it might evolve in future releases.

Topics touched on include:

  • transaction concepts
  • demand paging and storage
  • write ahead logs
  • checkpointing
  • recovery
  • comparison with "ARIES" and with other RDBMSs
  • undo log proposal
  • rollback and recovery with undo logs
  • MVCC and time travel with undo logs