Indexing
Detecting and Fixing PostgreSQL Index Bloat with REINDEX CONCURRENTLY
PostgreSQL index bloat: measure it with pgstattuple, understand why B-trees inflate, and rebuild online with REINDEX CONCURRENTLY without downtime.
[...] PostgreSQL Index
PostgreSQL
Troubleshooting Slow PostgreSQL Queries with EXPLAIN ANALYZE and pg_stat_statements
PostgreSQL slow query troubleshooting with EXPLAIN ANALYZE and pg_stat_statements: find, diagnose, and fix slow queries in production, step by step.
[...] 
Cloud Databases
Setting Sail: Installing CloudNativePG (CNPG) for PostgreSQL on Kubernetes
Running PostgreSQL on Kubernetes used to feel like a daunting challenge reserved for platform engineering teams with deep operational expertise. That reality has changed. With CloudNativePG (CNPG), deploying a production-grade PostgreSQL cluster on Kubernetes is [...]
MinervaDB
PostgreSQL 18 Performance Configuration Matrix: New Parameters and MinervaDB Tuning Recommendations
The release of PostgreSQL 18 introduces one of the most consequential rounds of configuration changes the project has shipped in years. For database engineers and site reliability teams, understanding PostgreSQL 18 performance tuning is no [...]
Datatbase Systems
How to Do UPDATE … LIMIT in PostgreSQL (With Standard SQL Alternatives)
If you have ever migrated a workload from MySQL to PostgreSQL, you have probably hit a wall the first time you tried to run a statement like UPDATE mytable SET status = 'done' LIMIT 100;. [...]
Performance
btree_gist improvements in PostgreSQL 18
The btree_gist improvements in PostgreSQL 18 are one of the most practical performance wins shipping in this release for teams that depend on exclusion constraints, composite indexes, and nearest-neighbour search. The btree_gist extension lives in [...]
MinervaDB
Should I Rebuild My PostgreSQL Index? When and How to REINDEX
Few maintenance questions generate as much confusion in the PostgreSQL community as this one: should I rebuild my PostgreSQL index, and if so, how often? Database administrators arriving from other systems frequently ask, "How can [...]
MinervaDB
Key Management in PostgreSQL: Why Encryption Depends on It
Key management in PostgreSQL has quietly moved from a "nice to have" to a hard requirement for most deployments. Data-at-rest encryption is now a baseline expectation, yet encryption alone rarely tells the full story. The [...]
Datatbase Systems
PostgreSQL Rogue Index Troubleshooting Tips and Tricks in PostgreSQL 17
If you have been managing PostgreSQL databases for any length of time, you have almost certainly run into the situation where an index that was supposed to help your queries is somehow making things worse. [...]
Data Warehousing
How to Safely Upgrade PostgreSQL Extensions Without Breaking Production
Safely Upgrade PostgreSQL Extensions for production PostgreSQL: architecture, tuning, HA and observability playbook by MinervaDB engineers.