Presented by:

C8e6da29e183d6cce275ea7ddce598fc

Kaushik Iska

ClickHouse

Kaushik Iska is a database systems expert and open-source contributor, specializing in PostgreSQL replication, distributed systems, and real-time data movement. He is the Co-founder and former CTO of PeerDB, a high-performance PostgreSQL replication system, which was acquired by ClickHouse. At ClickHouse, he leads database integrations, focusing on seamless real-time data replication from PostgreSQL to modern analytical platforms.

Kaushik has deep expertise in logical replication, Change Data Capture (CDC), and performance optimizations for large-scale data systems. He has contributed to open-source projects like PeerDB, ClickHouse, and Flutter, and has worked on high-impact distributed computing projects at Google and SafeGraph.

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:
Seminole E
Conference:
Postgres Conference 2025
Language:
Track:
Essentials
Difficulty:
Medium