MinervaDB Blog: Mastering WebScale Database Infrastructure

PostgreSQL Disaster Recovery Kubernetes: Simplifying Business Continuity

Introduction: In the digital age, businesses cannot afford to overlook the importance of disaster recovery. With increasing reliance on data, system outages or data loss can have catastrophic consequences, leading to significant disruptions and financial […]

PostgreSQL Isolation Levels: Building Optimal and Scalable Applications

Isolation levels in PostgreSQL play a crucial role in ensuring the consistency, performance, and scalability of your applications. By understanding and selecting the appropriate isolation level, you can develop optimal and scalable PostgreSQL-based applications. Let’s […]

MySQL Streaming Versus Blocking Operators Explained

In MySQL, operators in a query execution plan can be classified as streaming or blocking. This classification is based on how they process and propagate rows during query execution. Let’s explore the differences between streaming […]

InnoDB Redo Performance: Troubleshooting Tips and Tricks

Troubleshooting redo performance in InnoDB involves identifying and addressing potential bottlenecks or issues that affect the efficiency of redo log processing. The redo log plays a critical role in ensuring data durability and crash recovery […]

MySQL Scalar Subquery Unnesting transformation

Scalar subquery unnesting is a transformation technique that the MySQL optimizer uses to optimize queries involving scalar subqueries. Scalar subqueries return a single value. You typically use them in expressions or as part of the […]

How to control MySQL execution plans with hints?

In MySQL, you can use query hints to give suggestions or directives to the query optimizer. These hints guide the optimizer on how to generate the execution plan for a specific query. As a result, […]

PostgreSQL Statistics: How to Gather Them Only When Stale

In PostgreSQL, you can gather statistics only when they become stale by using the pg_stat_statements extension along with the track_activity_query_size configuration parameter. Follow these steps to achieve this: CREATE EXTENSION pg_stat_statements; 3. Query the pg_stat_statements […]

PostgreSQL SQL Plans: Why They Change for the Worse

In PostgreSQL, several reasons can cause SQL statement plans to worsen over time. These changes may lead to decreased query performance and unexpected behavior. Below are some common factors that contribute to deteriorating SQL statement […]

PostgreSQL Concurrent Statistics: How to Implement Concurrent Gathering

Concurrent statistics gathering in PostgreSQL allows the system to collect table and column statistics without blocking concurrent read and write operations. As a result, this feature ensures accurate and up-to-date statistics while minimizing the impact […]

PostgreSQL Bind-Aware Cursor Sharing: How to Force It in a Query

In PostgreSQL, you can force a query to use bind-aware cursor sharing by utilizing the CURSOR_SHARING parameter. By setting CURSOR_SHARING to ‘FORCE’, PostgreSQL will attempt to share cursors for similar queries with different literal values. […]

The Data Transformation Company

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

MinervaDB Blog