Database Optimization

Data Consistency Problems- Part 9 of About Distributed Systems

The combination of the two characteristics of replication - master-slave and timeliness, is causing data consistency risks.

400x Faster HTAP Real-time Data Analysis with PolarDB

In this article, we‘ll discuss the development process of PolarDB MySQL and share our thought process behind the scheme selection.

PostgreSQL-Based Automatic Performance Diagnosis and Optimization

This short article discusses Postgres Query Analysis and optimization.

Jingdong: Flink SQL Optimization Practice

This article focuses on the optimization measures of Jingdong in Flink SQL tasks, focusing on the aspects of shuffle, join mode selection, object reuse, and UDF reuse.

A Detailed Explanation of the Detection and Processing of BigKey and HotKey in Redis

This blog introduces BigKey and HotKey in Redis and discusses what leads to HotKeys or BigKeys, how to recognize HotKeys or BigKeys, further, the problem it brings, and ways you can take to handle.

An Introduction to Subqueries

This article shares the optimization techniques of subqueries and tips on handling subqueries in distributed databases.

Detailed Explanation of Query Rewriting Based on Materialized Views

This article describes the definition of materialized view for databases and ways to rewrite queries based on it.

How to Implement Join Operation on Distributed Databases

This article explores several ways for implementing join on distributed databases, namely Lookup Join using PolarDB-X.

Query Performance Optimization – Runtime Filter

In this blog, we'll introduce Runtime Filters and discuss how it can help improve query performance of the Join operation for databases.

Making SQL Optimizer More Accurate: AnalyticDB for PostgreSQL Auto Analyze Feature

This blog introduces the AnalyticDB for PostgreSQL Auto Analyze Feature and discusses how it helps users collect more accurate statistical information.

On the Analysis of Sharding

This article provides a detailed analysis on changing a single database with a single table into multiple databases with multiple tables through sharding.

Secondary Index in Alibaba Cloud ClickHouse – Best Practices

This article introduces several methods for optimizing single-table analysis and query performance of ClickHouse and describes the DDL syntax in detail.

Flink: How to Optimize SQL Performance Using Multiple-input Operators

In this article, the author explains how to optimize SQL performance in Apache Flink using multiple-input operators.

PostgreSQL: How libpq Helps Configure Multi-Backend Connection Preferences

In this article, the author explains how libpq can support configuring multiple backend connection preferences, including read-only, prefer-read, and prefer-write.

How to Use PostgreSQL log_fdw to Query Logs

In this article, the author explains how to use PostgreSQL log_fdw to query log data directly in ApsaraDB RDS for PostgreSQL.

PostgreSQL: How to Optimize the GiST Index Scanning

In this article, the author explains three methods to optimize the GiST index scanning to limit resource wastage in PostgreSQL.

How DMS Can Save the Life of DBAs?

In this article, we'll discuss how Alibaba Cloud DMS saves a lot of unnecessary overhead of a DBA and how enterprises can make use of it in their daily operations.

PostgreSQL: ST_Value Function Usage Examples to Optimize Raster Data in a Database

In this article, we'll discuss optimizing raster data in PostgreSQL databases using the ST_Value function and describe various optimization methods.

PostgreSQL Best Practices: Overcoming Ride-Hailing Conflicts Arising in a Trip Dispatch System

In this article, the author discusses optimizing the PostgreSQL database to overcome ride-hailing conflicts in crowded areas during peak hours.

Use Geometry Split to Optimize PostgreSQL Performance in GiST Index-based Polygon Search

In this article, the author discusses geometry split in PostgreSQL and describes how to use it to optimize performance in GiST index-based polygon search with example code.