Part 3 of this Series introduces aggregation subquery promotion, a rewrite strategy for aggregation-related subqueries, and the pitfalls of this rewrite strategy.
Part 2 of the OceanBase Rewriting Series focuses on the strategy of rewriting subqueries in existential determination predicates into SEMI/ANTI JOIN.
This short article explains PostgreSEL group filtering and aggregation usage.
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.