Presented by:

196bafe93ccff5ec009c8efb078ebe26

Kevin Biju

from Clickhouse
No video of the event yet, sorry!

Checkout the slides

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 6 - 10:45
Duration:
45 min
Room:
Grand Ballroom 1
Conference:
PGConf India, 2025
Language:
Track:
Database Administration
Difficulty:
Medium

Happening at the same time:

  1. Navigating Challenging Customer Escalations in PostgreSQL: Strategies for Resolution and Prevention
  2. Start Time:
    2025 March 6 10:45

    Room:
    Neptune

  3. Understanding Write-Ahead Logging (WAL) in PostgreSQL
  4. Start Time:
    2025 March 6 10:45

    Room:
    Jupiter

  5. Performance is a feature: accelerating Postgres system performance with PL/Rust
  6. Start Time:
    2025 March 6 10:45

    Room:
    Grand Ballroom 2