ITPUB

Dec 12, 2017 · Databases

Understanding PostgreSQL’s Subquery Planner: How Query Optimization Works

This article explains how PostgreSQL transforms and rewrites query trees, why a completed transform‑rewrite tree may not be optimal, and details the subquery_planner’s role, tuple_fraction handling, and the step‑by‑step logical optimization process used to generate efficient execution plans.