Re:JIT-Compiling SQL Queries in PostgreSQL Using LLVM
by mulmen on Monday February 22, 2021 @05:46AM
(#26222988)
How does complexity relate to cost? Is it just a matter of weight?
[ Parent
| on HN ]
Re:JIT-Compiling SQL Queries in PostgreSQL Using LLVM
by murkt on Monday February 22, 2021 @06:06AM
(#26223137)
What I called complexity is an amount of different nodes (not sure this is the proper term) in a query plan. So, the more complexity for a given cost - the more work JIT needs to do.
Re:JIT-Compiling SQL Queries in PostgreSQL Using LLVM
by mulmen on Monday February 22, 2021 @03:25PM
(#26230074)
But the planner sums each step in the plan so isn’t a more complex plan already more expensive? Or is the addition of another step not adequately considered in that cost?
Re:JIT-Compiling SQL Queries in PostgreSQL Using LLVM
by murkt on Tuesday February 23, 2021 @06:33AM
(#26236108)
A more complex plan isn't already more expensive in a way that captures how much work the JIT will need to do. I think I'll need to write a separate blog post about that, with details and examples.