Presented by:

Display pic

Sai Srirampur

ClickHouse Inc

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