Session
Time Travel PostgreSQL queries with ephemeral database branches
Time Travel Queries in PostgreSQL refer to a method of querying data that allows users to see the state of the database at a specific point in the past. This feature is not inherently built into PostgreSQL but can be implemented through various techniques.
One example where Time Travel Queries are useful debugging tools is Point-in-Time Recovery (PITR).
The issue for developers is that PITR in PostgreSQL involves multiple components such as base backups, write-ahead logging (WAL), WAL archiving, and recovery procedures. Setting up and configuring these components correctly requires a good understanding of PostgreSQL's internal workings and backup strategies. Developers might find it challenging to configure these components optimally, especially in more complex environments.
In this talk, we will cover how cloud-native PostgreSQL architectures, a custom storage system and ephemeral database branches streamline the implementation of Time Travel Queries, saving developers countless hours recovering data from backups. We will cover techniques that will help application developers focus on their product rather than managing their database infrastructure.
In addition to learning how to use Time Travel Queries in PostgreSQL, developers will learn about:
- PITR, problems it solves, and its challenges
- Write-Ahead Log in PostgreSQL
- Cloud-native PostgreSQL architectures
- Ephemeral database branches
I can't wait to see you all at the talk
This talk is for any developer with basic knowledge of SQL. However, it will go over complex architectural decisions that make Time Travel Queries native in PostgreSQL.
![](https://sessionize.com/image/bfd8-400o400o2-UEqHkugioEP2trpJPEj1Ef.jpg)
Raouf Chebri
Help developers be more productive
Genève, Switzerland
Links
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top