Skip navigation
Robert Haas

Robert Haas

VP, Chief Architect - Database Servers @ EnterpriseDB

Robert has been involved in the PostgreSQL project since 2008, first as a patch reviewer and committer and a later as a major developer. Prior to that, he was a PostgreSQL application developer for nearly ten years. Features he has worked on include incremental backup (16), backup compression, backup targets, and backup manifests (13-15), parallelism (9.4-11), the replacement of System V shared memory with anonymous shared memory (9.3), read and write scalability improvements (9.2), index-only scans (9.2), unlogged tables (9.1), and left join removal (9.0). He works at EnterpriseDB as VP, Chief Architect, Database Servers.

POSETTE 2025 Talk

Incremental Backup in PostgreSQL

(Livestream 1)

In this talk, I'll discuss the incremental backup feature which I developed for PostgreSQL 17. The talk will discuss how we determine what data has changed, and why the chosen approach was selected. It will then review in some detail how incremental backups can be taken and restored.

Podcast Appearances

talk bubbles
Join the conversation

Use the hashtag #PosetteConf