1.4.10 Planner Hook: When It Fires, How to Use It
Everything from 1.4.1 through 1.4.9 happened inside a single function, standard_planner() . Building paths, costing them, searching for a join order, …
Latest News
⚑ Report a ProblemTech news from the best sources
All topics
AI
Gear
News
Tech
agents
ai
api
architecture
automation
beginners
career
database
devchallenge
devops
discuss
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
tutorial
typescript
webdev
1.4.9 Planner Preprocessing: Subquery Pull-up, Predicate Pushdown, Equivalence Classes
So far we have seen the planner build candidate paths and rank them by cost, choose join methods and join orders, and estimate those costs from statis…
1.4.7 Parallel Cost: When to Go Parallel and How Many Workers
The planner weighs how to read a table, how to join, and how to aggregate by cost, and picks the cheapest candidate. Parallel query is one more decisi…
1.4.6 Aggregate Cost: Choosing HashAgg vs GroupAgg
A query like SELECT region, COUNT(*) FROM sales GROUP BY region folds many rows together, collapsing each group into a single value. This folding of m…