Docker Compose Postgres Backup: pg_dump, Cron and Restore Tests
Back up Postgres in Docker Compose with pg_dump via compose exec, schedule it with host cron, ship dumps off-host, and automate a restore test that proves it works.
13 min read
Tag
postgresql
How to Reduce Database Costs: Query Tuning, Indexing and Sizing
Find the slow queries that cost the most, index them deliberately, control storage growth, and right-size your PostgreSQL instance from measured load.
16 min read
PostgreSQL Connection Pooling: PgBouncer, max_connections and Sizing
Learn why PostgreSQL connections are costly, how app pools and PgBouncer work together, how to size pools, and when transaction-mode pooling breaks your app.
16 min read
Modular Monolith Database Design: Schemas, Ownership and Foreign Keys
Design a modular monolith database in PostgreSQL: schema per module, enforced data ownership, cross-module foreign keys, safe cross-module queries and migrations.
14 min read
PostgreSQL Backup and Restore: pg_dump, PITR and Restore Testing
Choose between pg_dump and base backups with WAL archiving based on RPO and RTO, run point in time recovery, and prove backups work with scheduled restores.
14 min read
PostgreSQL Indexing for Application Developers: A Practical Guide
Learn how B-tree indexes work, how to verify them with EXPLAIN (ANALYZE, BUFFERS), design composite and partial indexes, and ship index changes safely.
14 min read
Database Connection Pool Sizing for Monoliths Under Heavy Load
Size database connection pools from real database capacity and a global connection budget, tune HikariCP, use PgBouncer, and diagnose connection exhaustion.
14 min read
PostgreSQL Table Partitioning for Time-Series Data and Retention
Learn PostgreSQL range partitioning for time-series tables: pick granularity, verify partition pruning, automate partitions, and drop old data cheaply.
13 min read
PostgreSQL Autovacuum Tuning for Busy Tables: Stop Table Bloat
Learn how dead tuples cause table bloat, how autovacuum triggers, and how to set per-table thresholds and cost limits for high-churn PostgreSQL tables.
13 min read
Postgres SKIP LOCKED Queue: Build a Job Queue with Row-Level Locking
Build a Postgres job queue with FOR UPDATE SKIP LOCKED step by step: schema, dequeue query, worker models, retries, idempotency, vacuum and trade-offs.
14 min read