PGCon2019 - 3.4
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 |
| Feedback | |
|---|---|
|
Did you attend this event? Give Feedback |
Transactions
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