Presented by:

43e7696a35a5a4451a9a2ad8fe270fe6

Robert Haas

from EnterpriseDB

Robert Haas is a PostgreSQL major contributor and committer. PostgreSQL features which he has authored or coauthored include unlogged tables, fast-path locking, index-only scans, and parallel query. PostgreSQL features written by others which he has reviewed and committed include partitioning, logical decoding, event triggers, and foreign tables. He works at EnterpriseDB as VP, Chief Database Scientist.

No video of the event yet, sorry!

This talk will be a deep dive into the new incremental backup feature which has been committed for (hopefully) inclusion in PostgreSQL 17.

First, I'll explain how the feature works from a user perspective, and briefly discuss some possible use cases.

Second, I'll discuss the architecture of the feature, both how it actually works and alternative designs which I considered and ultimately rejected.

Third, I'll discuss some consequences of the design, both in terms of some interesting corner cases that are allowed and also, importantly, how we're able to reject cases where the user has done something that is not valid.

Finally, I'll discuss possible future improvements -- things that don't work now, but potentially could with more work.

Date:
2024 February 29 - 10:50
Duration:
40 min
Room:
Grand Victoria A
Conference:
PGConf India, 2024
Language:
Track:
Database Engine Developers
Difficulty:
Medium

Happening at the same time:

  1. A PostgreSQL fork for horizontal scalability: YugabyteDB
  2. Start Time:
    2024 February 29 10:50

    Room:
    Robusta + Arabica

  3. Seamlessly monitor and troubleshoot your database performance problems with Query Insights for PostgreSQL
  4. Start Time:
    2024 February 29 10:50

    Room:
    Grand Victoria B