×
Partition Pruning

Pagination at Scale: How PolarDB-X Handles 10K+ QPS Queries over 100-Billion-Row Tables

This article details how PolarDB-X optimizes pagination on massive distributed tables using partition pruning, late materialization, and deterministic indexing.

Introduction to the Core Features of the Partitioned Table in PolarDB for PostgreSQL

This article introduces the advantages of partitioned table strategies and discusses query optimization features and index options for PolarDB for PostgreSQL.