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.
PostgreSQL administration field guide
Field notes for the production operator.
Evidence-led guides for diagnosing the system in front of you: what to inspect, what the signal means, and how to change it without creating a second incident.
Latest entries
Read the evidence trail
13 publishedpg_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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
What pgdba.dev is
A field guide to PostgreSQL administration — what this site covers, who it's for, and what to expect.