MinervaDB Blog: Mastering WebScale Database Infrastructure

PostgreSQL Median Absolute Deviation: Finding Outliers

In PostgreSQL, you can actively use the Median Absolute Deviation (MAD) to identify outliers in a dataset. Since MAD is a robust statistic, it measures variability more effectively than traditional metrics. Moreover, it remains less […]

PostgreSQL isnumeric: Identifying Strings That Can Be Treated as Numbers

In PostgreSQL, you can apply the isnumeric function to identify strings that PostgreSQL can treat as numbers. The isnumeric function returns TRUE if all characters in the string are numeric, and FALSE otherwise. Here is an […]

PostgreSQL Alphanumeric String isalnum: Determine If a String Is Alphanumeric

PostgreSQL Table Column Limit: Safely Increasing It Beyond 1664

If you’ve ever encountered the PostgreSQL column limit of 1,664 columns per table, you know it can be a real hurdle when designing wide tables. This limit is enforced by the internal MaxTupleAttributeNumber parameter. In […]

Prevent Error PostgreSQL: Using IF [NOT] EXISTS for Object Creation and Removal

The IF [NOT] EXISTS DDL clause is a useful feature in PostgreSQL that can help prevent errors during object creation and removal. This clause allows database administrators to specify whether or not to create or […]

PostgreSQL Index Wildcard Explained

Index wildcard is a technique used in PostgreSQL to create an index on a partial string in a column, rather than indexing the entire column. This technique can improve query performance when searching for data […]

Optimal SQL PostgreSQL: Simple Steps for Implementing Optimal Programs

The SQL parser in PostgreSQL is implemented using a combination of lexical analysis, syntax analysis, semantic analysis, and code generation. The parser first converts the input SQL text into tokens, and then performs syntax and […]

Troubleshooting PostgreSQL Query Performance

Monitoring query latency, wait events, and locks in PostgreSQL helps identify and diagnose performance bottlenecks. Here’s a guide on how to monitor these aspects: Here’s a sample query to gather information about locks, wait events, […]

InnoDB History Length: What to Do When It Increases Significantly

Introduction The InnoDB history list length can grow significantly if there are long-running transactions that generate a lot of undo logs or if there are frequent transactions with large amounts of data being modified. This […]

MySQL UNDO Operations: Tuning Guide

In MySQL, undo operations are used to provide transactional consistency and to allow for rolling back changes made to the database during a transaction. Undo operations are implemented in the InnoDB storage engine, which is […]

The Data Transformation Company

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

MinervaDB Blog