Understanding Query Transformation in PostgreSQL CBO Query transformation plays a crucial role in the PostgreSQL Cost-Based Optimizer (CBO). It enables the optimizer to modify a user’s SQL query to generate a more efficient query plan. … Continue reading Looking under the hood of query transformation (done by CBO) in PostgreSQL with a simple real-life example