Amit Kapila

PostgreSQL's logical decoding framework has emerged as a foundational primitive for Change Data Capture (CDC) in enterprise data architectures, enabling real-time propagation of database changes to heterogeneous downstream systems.

Logical replication in PostgreSQL is rapidly transforming, opening up new possibilities for data management and distribution. This talk will explore the anticipated future direction of this crucial feature, emphasizing how upcoming capabilities will empower users in their daily workloads.

This talk will focus on explaining the key features like incremental backup, upgrades of logical replication setup, etc., and performance improvements done for PostgreSQL 17.

The way to distribute data from PostgreSQL has evolved over the past decade, making it simpler to build systems for high availability, move data to other locations, or manage independent shards.

In this presentation, I will start with how PostgreSQL has evolved over years regarding large Enterprises. Then, I'll speak about (a) Key features in PostgreSQL-15 in the areas like SQL (a new SQL statement MERGE), JSON, backups, compression, Logical Replication, security, etc., (b) Performance improvements like sorting data when sorting over larger data sets, postgres_fdw can now enable...

In this talk, I will tell how the Logical Replication has been evolved over years in PostgreSQL. This will explain some of the major recent enhancements like facilitating logical replication of two-phase and large in-progress transactions.

This talk will cover my journey to Postgres committer. I will talk about what led me to start working with the Postgres community and how my work and commitment has improved over time.