Tag: postgres

Docker volumes, version pinning, health checks, and tuning. A production-ready Postgres Compose template with init scripts and backup strategy.

How to safely add a NOT NULL column with a live backfill on a 200M-row Postgres table without locking your users out or scheduling any maintenance downtime.

Build a real Postgres 17 HA cluster with Patroni 4.x, etcd 3.5, and HAProxy, fully automatic failover, tested switchover procedure, zero manual babysitting.

Postgres table bloat killing your query performance? Compare VACUUM FULL vs pg_repack and learn how to reclaim disk space live without any scheduled downtime.

pg_stat_statements is far more than a slow query log. Here is what most tutorials skip entirely: tail latency percentiles, cache hit ratios, and WAL bloat.

Learn to read Postgres EXPLAIN ANALYZE output without losing your mind. Costs, row estimates, buffer hit stats, and the index and query fixes that matter most.

Run PostgreSQL 18 on ZFS for atomic snapshots, lz4 compression, and silent corruption detection. Tuning guide, backup automation scripts, and the real pitfalls.

SQLite is brilliant until you need concurrent writes, replication, or online migrations. Here's the actual line where Postgres earns its keep.

A kernel upgrade halved one team's PostgreSQL throughput. The fix was kernel tuning: huge pages, THP, swappiness, I/O scheduler. Here's what matters and why.

Decode the postgresql:// connection string, host, port, database, SSL mode, and the gotchas that cause connection refused at deploy time.

Wiki.js is a gorgeous self-hosted wiki with Markdown, WYSIWYG, and Git sync, Docker Compose setup with PostgreSQL backend.