pgdba.dev

The PostgreSQL administration field guide

Browse by topic

Configuration & TuningDeep, parameter-level guides to postgresql.conf, pg_hba.conf, memory, connections and production-grade defaults.Replication & High AvailabilityArchitecting resilient Postgres clusters with streaming replication, Patroni, and load balancers.Indexing StrategiesHow Postgres indexes actually work, and how to pick the right one for JSONB, arrays, geo, and relational data.Query PerformanceEXPLAIN-driven diagnosis and tuning of slow queries, plans, and workloads on Postgres and beyond.Backups & Disaster RecoveryBackup strategy, restore drills, and disaster recovery planning for production Postgres.Version UpgradesPlanning and executing minor and major PostgreSQL upgrades with minimal downtime and risk.Framework & Tool IntegrationsWiring PostgreSQL correctly into application frameworks, ORMs, and observability tools.

Latest

Indexing JSONB in PostgreSQL: GIN Operator Class Guide
Choose the right GIN operator class for JSONB indexes in Postgres—jsonb_path_ops vs jsonb_ops, expression indexes, and real EXPLAIN benchmarks.
2026-08-04
pg_upgrade Checklist for a Boring, Downtime-Safe Postgres Upgrade
A field-tested pg_upgrade checklist covering --link mode, --check, logical replication, and the rollback point that actually matters.
2026-08-04
Postgres Backup and Disaster Recovery: A Practical Playbook
Real-world postgres backup and disaster recovery guide: WAL archiving, PITR, pgBackRest, RPO/RTO targets, and a restore drill that actually works.
2026-08-04
Postgres Indexing Basics: What EXPLAIN Actually Shows
Learn how Postgres picks indexes, when it skips them, and how to read EXPLAIN ANALYZE buffers instead of guessing at query speed.
2026-08-04
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.
2026-08-04
postgresql.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.
2026-08-04
Spring Boot PostgreSQL Configuration for Production
The default Spring Boot PostgreSQL setup works in demos, not production. Fix HikariCP pool sizing, Hibernate dialect, batching, and DataSource settings.
2026-08-04
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
2026-08-03
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.
2026-08-03
Postgres Index Types: B-Tree vs GIN vs GiST vs BRIN
Postgres index types explained: when to use B-tree, GIN, GiST, or BRIN, with real EXPLAIN output and a decision table for indexing strategy.
2026-08-03
Postgres Query Performance Tuning: A Practical Workflow
A step-by-step Postgres query performance tuning workflow: pg_stat_statements, EXPLAIN ANALYZE BUFFERS, indexing, and safe verification in production.
2026-08-03
PostgreSQL Streaming Replication Setup: The Missed Half
Configure PostgreSQL streaming replication step by step — pg_basebackup, standby.signal, replication slots, lag checks, and safe promotion.
2026-08-03
What pgdba.dev is
A field guide to PostgreSQL administration — what this site covers, who it's for, and what to expect.
2026-08-01