A lesser known Superpower of Postgres Logical Replication: Protocol Versions
Presented by:

Sai Srirampur
Sai leads all the Postgres and Database integration efforts at ClickHouse. He was the CEO and Co-founder of PeerDB, which he sold to ClickHouse. Sai is a Postgres enthusiast who's helped hundreds of companies get the most out of their databases. He built Postgres tools at Microsoft and was an early Citus Data employee (acquired by Microsoft).
No video of the event yet, sorry!
Did you know that Logical Replication has four protocol versions, each adding more features to the Postgres Logical Replication protocol, from drastically impacting performance to supporting more complex SQL commands?
In this talk, we will take a deep dive into each of these protocol versions and explore the use cases where they make sense, from the perspective of both Postgres and an external ETL tool. We will also present real-world benchmarks comparing the performance of various versions. The benchmarks will be based on a heavy workload with large transactions, showing how newer versions dramatically improves logical decoding performance and reduces replication slot growth—a major concern in such workloads since it can have adverse effects on the source Postgres database.
This talk is inspired by this blog post on Exploring Versions of the Postgres Logical Replication Protocol (https://blog.peerdb.io/exploring-versions-of-the-postgres-logical-replication-protocol), which was well received by the community.
- Date:
- 2025 March 20 15:30 EDT
- Duration:
- 50 min
- Room:
- Gold Coast 3&4
- Conference:
- Postgres Conference 2025
- Language:
- Track:
- Essentials
- Difficulty:
- Medium