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.
Tag: postgres
All the articles with the tag "postgres".
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.