Gunnar Morling 11/30/2022

The Insatiable Postgres Replication Slot

Read Original

A technical deep dive into diagnosing unexpected Write-Ahead Log (WAL) growth and rapid disk space consumption in an idle Amazon RDS Postgres database. The article details how an inactive logical replication slot, created for a CDC demo with Apache Flink, caused ~18 GB/day of WAL retention. It includes steps to reproduce the issue, analyze relevant Postgres metrics, and identify the root cause.

The Insatiable Postgres Replication Slot

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser