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 DBA
PostgreSQL
Diagnosing Autovacuum Lag and Table Bloat in PostgreSQL Production Systems
PostgreSQL autovacuum tuning for production: diagnose autovacuum lag, measure table bloat, fix per-table thresholds, and prevent wraparound risk.
[...] 
Database Performance Tuning
PgBouncer Pool Saturation: Diagnosing Connection Bottlenecks in PostgreSQL
PgBouncer performance tuning for PostgreSQL: diagnose pool saturation with SHOW POOLS, read cl_waiting correctly, size pools, and fix bottlenecks.
[...] 
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;. [...]
MinervaDB
Patroni Standby Cluster: Cascading Replication for PostgreSQL High Availability
PostgreSQL has become the database of choice for organizations that demand reliability, and Patroni sits at the center of most production-grade PostgreSQL high availability deployments. In this in-depth guide we walk through one of Patroni's [...]
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 [...]