PGCon2019 - 1.0.8

PGCon 2019
The PostgreSQL Conference

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

Transaction Logging

In PostgreSQL and other systems

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