Topic

#cdc

Illustrated overview of Postgres: EXPLAIN ANALYZE, VACUUM, and Why BI Must Leave the Primary

PostgreSQL

Aug 27, 20264 min read

Postgres: EXPLAIN ANALYZE, VACUUM, and Why BI Must Leave the Primary

A BI scan on the orders primary froze autovacuum, the replication slot kept WAL, and the disk hit 91%. Read the plan, manage bloat, and keep CDC from filling the volume.

postgres
cdc

Debezium

May 17, 202614 min read

Debezium on Postgres: Replication Slots, Snapshots, and Applying Changes Idempotently

A production walkthrough of Postgres CDC with Debezium: how the replication slot fills your disk, how to snapshot a large table without locking it, and how to apply changes so replays are safe.

debezium
kafka
cdc