4 ms·
What about pre-compiling plans? With server-side prepared statements it would make sense to use entirely different planning time tradeoffs.
by kuschku 9y ago
What about pre-compiling plans? With server-side prepared statements it would make sense to use entirely different planning time tradeoffs.
- anarazel 9y agoIt's not that simple. Server side prepared statements are used to great effect in OLTPish scenarios too. A serviceable approach would be to perform additional optimizations based on the query's cost - but that's hard to do without incurring a complete replan, because of the bottom up dynamic programming approach of a good chunk of the planning.
- kuschku 9y agoWell, I’d love to see a way to set such a query planning cost target. There’s a few statements which I never change, but run thousands of times a day, and which are extremely expensive.