Patching the PostgreSQL JDBC Driver
Contributing to the PostgreSQL JDBC Driver to address the issue of runaway WAL growth in Logical Replication Software Engineer This blog post describes a recent contribution from Zalando to the Postgres JDBC driver to address a long-standing issue with the driver’s integration with Postgres’ logical replication that resulted in runaway Write-Ahead Log (WAL) growth. We will describe the issue, how it affected us at Zalando, and detail the fix made upstream in the JDBC driver that fixes the issue for Debezium and all other clients of the Postgres JDBC driver. Builders at Zalando have access to a low-code solution that allows them to declare event streams that source from Postgres databases. Each event stream declaration provisions a micro application, powered by Debezium Engine, that uses Postgres Logical Replication to publish table-level change events as they occur. Capable of publishing events to a variety of different technologies, with arbitrary event transformations via AWS Lambda,
Introduction This blog post describes a recent contribution from Zalando to the Postgres JDBC driver to address a long-standing issue with the driver’s integration with Postgres’ logical replication that resulted in runaway Write-Ahead Log (WAL) growth. We will describe the issue, how it affected us at Zalando, and detail the fix made upstream in the JDBC driver that fixes the issue for Debezium and all other clients of the Postgres JDBC driver. Postgres Logical Replication at Zalando Builders at Zalando have access to a low-code solution that allows them to declare event streams that source f
Explore this link on the map →saved by
related reading
- The Insatiable Postgres Replication Slot - Gunnar Morlingmorling.dev
- An Overview of Distributed PostgreSQL... | Crunchy Data Blogcrunchydata.com
- Scaling PostgreSQL to power 800 million ChatGPT users | OpenAIopenai.com
- Postgres WAL Files and Sequence Numbers | Crunchy Data Blogcrunchydata.com
- PostgreSQL: Documentation: 18: 54.5. Logical Streaming Replication Protocolpostgresql.org
- Write-Ahead Loggingsqlite.org
- Setting up PostgreSQL for Debezium – Elephant Tamerelephanttamer.net
- Benchmarking How Workflow Execution Scales on Postgres | DBOSdbos.dev
- PostgreSQL: Documentation: 16: Chapter 31. Logical Replicationpostgresql.org
- Making Postgres 42,000x slower because I am unemployedbyteofdev.com
- Notice of Obsolescence — The Buildthebuild.com
- Schedule | POSETTE: An Event for Postgres 2024 - Citus Datacitusdata.com