OceanBase Rewriting Series: Best Practices for Promoting Subquery Performance

Part 3 of this Series introduces aggregation subquery promotion, a rewrite strategy for aggregation-related subqueries, and the pitfalls of this rewrite strategy.

OceanBase Rewriting Series: Subquery Promotion

Part 2 of the OceanBase Rewriting Series focuses on the strategy of rewriting subqueries in existential determination predicates into SEMI/ANTI JOIN.

PostgreSQL group x, sort by y, and get (N dynamic) Records for Each Group-Subquery + Subquery Aggregation Use

This short article explains PostgreSEL group filtering and aggregation usage.

PostgreSQL: How to Determine the Positions of Overlapping Points and Planes in PostGIS

In this article, the author discusses overlapping points and planes and determining their actual positions from a visual perspective in PostGIS.

Optimizing Time Series Querying on Alibaba Cloud RDS for PostgreSQL

We'll show you how to optimize the performance of time series data querying from seven seconds to seven milliseconds with Alibaba Cloud RDS for PostgreSQL.