PostgreSQL Archives - The Data Transformation Company

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;. [...]

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 [...]

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 [...]

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 [...]

Key management in PostgreSQL encryption and TDE key handling

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 [...]

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. [...]

PgBouncer PostgreSQL Connection Pooling: The Complete Guide to Eliminating Bottlenecks

PgBouncer PostgreSQL connection pooling is the definitive solution for enterprises struggling with database performance bottlenecks at scale. When applications slow to a crawl under heavy database load, the culprit is rarely what engineers expect. Slow [...]

Datadog PostgreSQL Observability

Practical Datadog PostgreSQL guide with working SQL examples, EXPLAIN ANALYZE walkthroughs, configuration tips, and production guardrails for PostgreSQL cl.

[...]

PostgreSQL Cost Optimization on RDS

PostgreSQL Cost Optimization for production PostgreSQL: architecture, tuning, HA and observability playbook by MinervaDB engineers.

[…]

PostgreSQL Checkpoint Tuning: Eliminating I/O Spikes and Recovery Risk

Default PostgreSQL checkpoint settings create latency spikes, inflate WAL volume, and put crash recovery at risk. This MinervaDB guide walks through every parameter, the new pg_stat_checkpointer view, and reference configurations for OLTP, write-heavy, and analytical workloads on PostgreSQL 16 and 17.

[…]