This article debunks the outdated MySQL 5M-row single-table limit myth, explaining how modern B+Tree architecture and hardware make large tables fully viable.
This article introduces why MySQL B-tree height stays within 4–5 layers even with tens of billions of rows, debunking the myth that single tables must be sharded after 5 million rows.
This article explains the Join Reorder optimization algorithm used by DuckDB.
This article explains how DuckDB’s LocalStorage efficiently handles INSERT operations within transactions using a shadow-table design and optimistic merging for bulk data.
This article announces Alibaba Cloud PolarDB’s support for PostgreSQL 18.
This article introduces the performance benefits of DuckDB-based analytical instances for ApsaraDB RDS for MySQL, and discusses whether ETL and wide tables are still necessary.
This article introduces how PolarDB‑X accelerates Top‑K and pagination queries using a multi‑level parallel Top‑K engine plus threshold‑based early‑termination of file scans.
This article introduces how Alibaba Cloud's PolarDB for PostgreSQL enables real-time HTAP through its In-Memory Columnar Index (IMCI) and integration with DuckDB.
This article will focus on explaining the purpose of all optimization rules implemented in DuckDB.
This article introduce the main concepts involved in each module of the execution layer, giving readers a general understanding of what each module does.
This article provides a detailed analysis of the table storage format based on the DuckDB v1.3.1 source code.
In this article, we'll explore how to set up, optimize, and scale database solutions using Alibaba Cloud RDS.
This article introduces PolarDB for MySQL's fully asynchronous execution architecture and its performance benefits for high-concurrency scenarios.
This article introduces how Alibaba Cloud has integrated DuckDB into MySQL as a new storage engine to dramatically improve its analytical query performance.
This article primarily focused on the file format overview and metadata storage.
This blog explores the new features, improvements, and the benefits MongoDB 8.0 brings to the table, making it a game-changer in the world of database management.
The article introduces PolarDB's achievement in setting a new world record for database performance and cost efficiency in the TPC-C benchmark
This tutorial describes how to migrate and replicate AWS RDS PostgreSQL to Alibaba Cloud PolarDB.
This article summarizes some common inefficient indexes and the causes of their inefficiency.
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.
