Time Travel Queries with Postgres

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.

Pizza is provided, and we also have a user group lending library of books & papers related to PostgreSQL and Databases.

NEW LOCATION: same place as the summer BBQ - the Fred Hutch Steam Plant building. (Entrance on Eastlake Ave) Typically it's not hard to find street parking nearby.