Time Travel Queries with Postgres
Presented by:
Harry Pierson
No video of the event yet, sorry!
Wouldn’t it be nice if you could query your database as it was ten minutes, ten hours, or ten days ago? It would make audits, troubleshooting, and period vs. period reporting so much easier. Once upon a time, Postgres supported time travel queries, but it was deprecated almost thirty years ago because of its abysmal performance. In this talk, we present a new implementation of time travel in Postgres using logical replication to create a special versioned database read replica. We’ll discuss algorithms to construct this replica and efficiently query it, and mechanisms to compact the replica’s data and bound its size.
- Date:
- 2024 November 7 09:40 PST
- Duration:
- 50 min
- Room:
- Dev: 422
- Conference:
- Seattle 2024
- Language:
- Track:
- Dev
- Difficulty:
- Hard