Presented by:

196bafe93ccff5ec009c8efb078ebe26

Kevin Biju

from Clickhouse
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:
Duration:
45 min
Room:
Conference:
PGConf India, 2025
Language:
Track:
Database Administration
Difficulty:
Medium