Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Apply (1) filters
5 blog posts in 13 categories

PostgreSQL: Query Parallelism in Action

A parallel query is a method used to increase the execution speed of SQL queries by creating multiple query processes that divide the workload of a SQL statement and executing it in parallel or at the same time. In this blog, we’ll explore this concept and how it relates to PostgreSQL.

More of My Favorite PostgreSQL Queries - and Why They Also Matter

This is the follow up to the popular blog ‘My favourite PostgreSQL queries and why they matter’. This new blog focusses on a particular query, multi-row UPDATE with a single CASE expression, and makes comparisons between that particular query, and one involving multiple single UPDATE statements.

My Favorite PostgreSQL Queries and Why They Matter

In today's data-driven world, data is valuable. Extracting insight, answering questions, and meaningful metrics from data by way of querying and data manipulation is an integral component of SQL in general. This blog presents a combination of 8 interesting, differing PostgreSQL queries or types of queries to explore, study, learn, or otherwise manipulate data sets.

Video: Database Troubleshooting Tips for DevOps

This video describes three database scenarios which a DevOps Team may face and how to resolve them using ClusterControl and ProxySQL.

Optimizer Hints for Faster MySQL Query Execution

MySQL uses a cost-based optimizer to determine the best way to execute a query. It usually does a great job, but not all the time. There are different reasons for that. In some cases, it might not have enough information about the data and plan queries in a non-optimal way.