dbaplus Community

May 22, 2018 · Databases

Understanding PostgreSQL Query Optimizer: Rules, Subqueries, and Cost Models

This article explains PostgreSQL's query optimizer from logical and physical perspectives, covering rule‑based and cost‑based optimization, syntax tree generation, subquery/subjoin lifting, selection push‑down, equivalence‑class reasoning, strictness of expressions, and practical SQL examples.