Tag: postgres

Postgres HA: Patroni + etcd + HAProxy

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 EXPLAIN ANALYZE Without Crying

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.

PostgreSQL on ZFS: Tuning, Snapshots, Pitfalls

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

Postgres vs SQLite for Home Lab Apps

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

PostgreSQL + Linux: Kernel Tuning That Actually Matters

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.