Debezium PostgreSQL CDC: Slots, Snapshots and Safe Consumers
Set up Debezium PostgreSQL CDC on Kafka Connect: logical replication slots, snapshots, event envelopes, idempotent consumers and WAL-safe operations.
13 min read
Tag
postgresql
PgBouncer Transaction Pooling: Prepared Statements and Session State
How PgBouncer transaction pooling works, why prepared statements and session state break, how to audit your app, and how to size and monitor pools.
13 min read
PostgreSQL Zero Downtime Migration: Expand and Contract in Practice
Run PostgreSQL schema changes without outages: lock_timeout with retries, expand and contract steps, batched backfills, NOT VALID constraints and concurrent indexes.
14 min read
FastAPI Async Database Access: SQLAlchemy Async vs asyncpg
Learn how SQLAlchemy async and asyncpg relate in FastAPI, how to wire sessions and connection pools, avoid lazy-loading traps, and pick the right layer.
13 min read
PostgreSQL Blocking Queries: Find the Root Blocker with pg_locks
Learn to trace PostgreSQL blocking queries to the root blocker with pg_stat_activity, pg_blocking_pids() and pg_locks, then prevent them with lock_timeout.
13 min read
PostgreSQL Index Types: B-Tree, GIN, BRIN and Partial Indexes
Learn how B-Tree, GIN, BRIN and partial indexes work in PostgreSQL, when each fits your data and operators, and how to verify the choice with EXPLAIN.
14 min read
Distributed Lock Redis vs Postgres: Redlock, Advisory Locks, Fencing
Compare Redis Redlock and PostgreSQL advisory locks, learn why lease-based locks fail, and when fencing tokens are required for correctness.
14 min read
NestJS Testcontainers: Integration Tests Against Real PostgreSQL
Run NestJS integration and e2e tests against a disposable PostgreSQL via Testcontainers, with real migrations, per-test isolation and a fast CI setup.
14 min read
Cursor vs Offset Pagination Performance in PostgreSQL APIs
Why OFFSET cost grows with page depth in PostgreSQL, how keyset pagination keeps it flat, and when each fits your API under real load.
13 min read
Multi-Tenant Monolith Database Design: Shared Tables vs Schema per Tenant
Compare shared tables with row-level security against schema per tenant for a multi-tenant monolith: isolation, migrations, performance, lifecycle, and cost.
15 min read
PostgreSQL EXPLAIN ANALYZE Slow Query Tuning with pg_stat_statements
Rank slow queries by total cost with pg_stat_statements, then use EXPLAIN (ANALYZE, BUFFERS) to find row misestimates and fix the real cause.
13 min read
Transactional Outbox Pattern: Reliable Events from PostgreSQL
Solve the dual write problem in PostgreSQL with the transactional outbox pattern: table design, polling and CDC relays, idempotent consumers and ordering.
15 min read