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 / tag
Configuration & Tuning
Every public pgdba.dev field note carrying this operational signal.
Tagged notes
4 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.