3 ms·
If the planner is faster than a cache lookup it makes me wonder how sophisticated it is and how much optimization is left on the table. Most apps I deal with q
by SigmundA 5y ago
If the planner is faster than a cache lookup it makes me wonder how sophisticated it is and how much optimization is left on the table.
Most apps I deal with queries are very regular and the plan cache makes it act like a prepared statement improving performance 99% of the time. Once in a while it works against you and you need to give it a hint to recompile or optimize for specific parameter values.