> blog --category
Postgres Series
10 posts2026
Postgres Series
- Procrastinate: Turning Postgres Into Your Task Queue (opens on Medium)
How PostgreSQL's LISTEN/NOTIFY and SKIP LOCKED quietly replace your message broker, and when they shouldn't.
- Postgres Learns to Speak Graph: Inside SQL/PGQ and PostgreSQL 19 (opens on Medium)
PostgreSQL 19 ships native graph pattern-matching with SQL/PGQ. Here's how CREATE PROPERTY GRAPH and GRAPH_TABLE work, and how they stack up
- PostgreSQL Internals, CDC, Kafka, and Distributed Systems Engineering Series (opens on Medium)
PostgreSQL WAL, logical replication, Kafka, CDC pipelines, and distributed systems lessons from production-scale systems.
- Kafka-Based PostgreSQL → Salesforce Architecture (Part 2): How the System Actually Works (opens on Medium)
Reconciling streaming CDC, batch-oriented APIs, and lakehouse storage in a production-grade PostgreSQL to Salesforce architecture.
- PostgreSQL to Salesforce at Scale: Evolving a CDC Pipeline with Kafka (opens on Medium)
From table-based buffering to a distributed log architecture for multi-consumer, high-throughput systems
- Building a Reliable PostgreSQL → Salesforce CDC Pipeline: Lessons from WAL, Replication, and Failure Isolation (opens on Medium)
Designing a serverless data pipeline with Azure Functions while protecting PostgreSQL using deterministic control loops
- Protecting PostgreSQL Primaries from Replication Slot Failures (opens on Medium)
Exporting slot telemetry and building an automated WAL protection control loop for high-throughput CDC pipelines.
- PostgreSQL Logical Replication at Scale: Database-Side Guardrails for 60M+ Change Events (opens on Medium)
Configuring replication slots, WAL retention limits, failover strategy, and monitoring to protect the primary under sustained peak load.
- PostgreSQL Logical Replication Internals: restart_lsn vs confirmed_flush_lsn Explained (opens on Medium)
How LSN movement controls WAL retention and disk stability
- Understanding PostgreSQL Logical Replication: The Complete End-to-End Flow (opens on Medium)
Understand how PostgreSQL streams row-level changes using WAL, logical decoding, replication slots, and subscriber feedback.