Database Performance

An In-Depth Analysis of Buffer Pool in InnoDB

This article aims to focus on the core functionalities of the Buffer Pool, providing an introduction to its interfaces, memory organization, page retrieval, and flushing.

PolarDB for PostgreSQL | Database Performance Optimization for High-Concurrency Queue Processing

This article describes the database optimization strategies and presents a demo illustrating how to boost database performance for queue processing tasks.

PostgreSQL v12: How pg_stat_statements Causes High-concurrency Performance Issues

In this article, the author discusses how enabling PostgreSQL pg_stat_statements in PG v12 causes high-concurrency performance issues.

PostgreSQL: How to Create Multiple Indexes for a Field?

In this article, we'll discuss how to create multiple indexes for the same column in a PostgreSQL database table to solve performance issues and overcome various constraints.

PostgreSQL v12 Performance: Alibaba Cloud ECS Local SSD vs. ESSD PL3

In this article, the author discusses and demonstrates the performance of PostgreSQL v12 with respect to local and cloud SSD storage types in Alibaba Cloud.