Name: Time Travel Queries with Postgres
Start: 2025-03-06T18:00:00-08:00
End: 2025-03-06T20:00:00-08:00
Location: Steam Plant - Fred Hutch Cancer Center

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.

Jeremy Schneider

Seattle Postgres

Technology

Database Professionals

LAMP

PostgreSQL

Geospatial

Database Integration & Migrations

Database Development

Real Time Analytics

Big Data

Harry Pierson is a seasoned software architect and engineer with over 30 years in the IT industry. He spent 20 years at Microsoft in various roles, pioneering technical evangelism and focusing on developer experiences. Today, he's an engineer at DBOS, working on their mission to dramatically simplify the way cloud applications are built, deployed, and secured. Outside of work, Harry is a husband and father, a beer league hockey player and an amateur powerlifter.

Seattle Postgres

Time Travel Queries with Postgres

Seattle Postgres

Details

Members are also interested in