postgresql.conf Settings for Production: A Practical Guide
Practical postgresql.conf tuning for production: shared_buffers, work_mem, checkpoints, autovacuum, and what to leave alone.
Field guide / topic hub
Configuration & Tuning
Parameter-level guides to postgresql.conf, pg_hba.conf, memory, connections, and production-grade defaults.
Operational notes
5 publishedpostgresql.conf Location: Find It on Any Platform
Run SHOW config_file in psql for the exact path, plus postgresql.conf locations for Debian, RHEL, Docker, macOS, Windows, and managed Postgres.
Almost every 'connection refused', 'no pg_hba.conf entry', or password-prompt-hangs-in-CI failure traces back to one of
Almost every 'connection refused', 'no pg_hba.conf entry', or password-prompt-hangs-in-CI failure traces back to one of three confusions — which pg_hba.conf lin
Postgres Free Space Map: Why DELETE Doesn't Shrink Tables
DELETE didn't free disk space? Learn how Postgres' Free Space Map, VACUUM, and truncation actually work — and when to reclaim disk for real.
What pgdba.dev is
A field guide to PostgreSQL administration — what this site covers, who it's for, and what to expect.