BT

Facilitating the Spread of Knowledge and Innovation in Professional Software Development

Write for InfoQ

Topics

Choose your language

InfoQ Homepage News Google Cloud Highlights Ongoing Work on PostgreSQL Core Capabilities

Google Cloud Highlights Ongoing Work on PostgreSQL Core Capabilities

Listen to this article -  0:00

Google Cloud has outlined its recent technical contributions to PostgreSQL, emphasizing improvements in logical replication, upgrade processes, and overall system stability. The update reflects ongoing collaboration with the upstream community and focuses on enhancements to the core engine aimed at addressing scalability, replication, and operational challenges.

The update summarizes engineering work carried out between July and December 2025, with a strong focus on advancing logical replication toward active-active configurations. One of the key developments is the introduction of automatic conflict detection, which allows the database to identify row-level conflicts during replication without manual intervention. This addresses a long-standing challenge in multi-node write setups, where conflicting updates could previously stall replication.

The direction toward active-active replication has also sparked discussion in the community about trade-offs in consistency models. Commenting on this, Franck Pachot noted:

Comparing 2-way logical replication with conflict resolution and Oracle RAC or Distributed SQL like CockroachDB or YugabyteDB is a misunderstanding of database consistency. One is last write wins, the other is ACID

At the same time, others see the progress as a broader signal of PostgreSQL’s evolution in enterprise environments. Janardhan Korapala wrote:

Massive milestone. When hyperscalers upstream enterprise-grade features like active-active replication, it signals that Postgres is now the undisputed enterprise default.

Additional improvements extend logical replication beyond table data to include sequences, reducing the need for manual synchronization during migrations or version upgrades. The team also contributed fixes to issues such as self-deadlocks in subscription management, which could occur when replication commands attempted to access locked resources on the same server.

A notable part of the work focuses on improving upgrade reliability and performance. Enhancements to pg_upgrade improve the management of large objects, reducing upgrade times for large-scale deployments. Additional updates increase resilience by retaining necessary WAL data during upgrades and ensuring that schema constraints are preserved correctly.

Beyond replication and upgrades, Google Cloud engineers contributed several bug fixes to improve robustness. These include handling invalid index pages in diagnostic tools, resolving issues with loading extensions from nested paths, and strengthening WAL flush logic to ensure durability in edge cases.

The company also highlighted ongoing work on future features, including a structured conflict log for replication, improvements to parallel data export in pg_dump, and enhancements to large-scale data handling.

About the Author

Rate this Article

Adoption
Style

BT