MinervaDB Blog: Mastering WebScale Database Infrastructure

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

Milvus Vector Database: 7 Powerful Scalable Search Tips

Milvus vector database has quickly become one of the most widely adopted open-source engines for powering similarity search at scale. As AI applications move from experimental notebooks into production systems that serve billions of requests, [...]

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

Five NoSQL Data Platforms That Changed the Way We Do Data Processing

NoSQL data platforms changed the way we do data processing more profoundly than almost any other shift in modern engineering. For most of the last four decades, the relational database was the only serious answer [...]

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

btree_gist improvements in PostgreSQL 18

Troubleshooting SQL Server 2022 IOPs for Optimal Performance

SQL Server 2022 IOPS (Input/Output Operations Per Second) performance is one of the most critical — and most frequently misdiagnosed — bottlenecks in production database environments. SQL Server 2022 introduces significant architectural enhancements, yet I/O [...]

SQL Server 2025 High Availability: Always On, Failover Clustering, and Maximum Availability

SQL Server 2025 High Availability has reached a new frontier with Microsoft's most advanced release to date. Whether you are a database administrator architecting enterprise workloads, a cloud engineer designing multi-region deployments, or a DevOps [...]

The Data Transformation Company

Data Architecture, Engineering and Operations for SQL, NoSQL, NewSQL, Cloud Native Data Platforms, Analytics and AI

MinervaDB Blog