Post Content
Trace the evolution of logical decoding and replication in PostgreSQL. Hari Kiran (OpenSource DB) explores this in his talk “Past, Present, and Future: Logical Decoding and Replication in PostgreSQL” at POSETTE: An Event for Postgres 2026. Abstract: Logical replication has evolved into a foundational capability for modern PostgreSQL deployments, enabling real-time data synchronization, partial replication. What began as a low-level decoding API in PostgreSQL 9.4 has now matured into a powerful feature, allowing for fine-grained control over what gets replicated and where.
In this talk, we’ll trace the journey of logical decoding and replication in PostgreSQL, from its early adoption through extensions like pglogical, to the robust native features introduced in recent PostgreSQL releases. We’ll dive into how these capabilities have empowered change data capture (CDC), zero-downtime migrations, and real-time analytics pipelines.
We’ll also explore how innovations in the ecosystem, particularly the work of Multi-master replication, are shaping the future of distributed PostgreSQL by enabling features like out-of-box asynchronous logical replication, automated DDL propagation, and eliminating the traditional limitations of read-only replicas or single-writer systems.
We’ll also explore how innovations in the ecosystem, especially multi‑master replication, are shaping distributed PostgreSQL by enabling features like out‑of‑the‑box asynchronous logical replication, automated DDL propagation, and removing the limitations of read‑only replicas and single‑writer system
Key takeaways:
– Understand the architecture and internals of logical decoding
– Compare native and extension-based logical replication
– Discover what’s next: DDL replication, performance tuning, and multi-master replication
Hari Kiran is a seasoned Database Engineer with nearly 18 years of experience in multiple domains of the IT Industry in Healthcare, Banking, Project & Portfolio Management, and CRM domains. Passionate about PostgreSQL helping Customers across geographies with Database Administration, Enterprise Implementations, Security and Hardening, Backup and Recovery, and Performance Tuning. Hari Kiran is a Founder of OpenSource DB.
► Video chapters:
⏩ 00:00 – Music & introduction
⏩ 00:40 – Speaker background and experience
⏩ 01:30 – Agenda: past, present, future roadmap
⏩ 02:34 – Physical vs logical replication explained
⏩ 04:27 – Inside logical decoding architecture
⏩ 07:59 – Origins in Postgres 9.4 and pglogical
⏩ 10:45 – Native replication evolution to PG18
⏩ 14:17 – Key features: filtering and parallel apply
⏩ 17:14 – High availability, failover, and conflict detection
⏩ 19:34 – Native vs extension-based replication tradeoffs
⏩ 21:18 – CDC pipelines and real-world use cases
⏩ 25:12 – Real-world patterns of logical replication
⏩ 26:42 – Performance tuning and common pitfalls
⏩ 27:55 – Future: multi-master distributed Postgres
⏩ 30:18 – Key takeaways and closing remarks
📕 Everything you need to know about POSETTE: An Event for Postgres can be found at: https://posetteconf.com
✅ Learn more: watch more POSETTE talks: https://aka.ms/posette-playlist
📌 Let’s connect:
LinkedIn: https://www.linkedin.com/company/posetteconf/
X – @PosetteConf, https://x.com/PosetteConf
Mastodon – @posetteconf, https://mastodon.social/@posetteconf
Bluesky – @posetteconf.com, https://aka.ms/posette-on-bluesky
#PosetteConf #PostgreSQL #database Read More Microsoft Developer
