Musing about using profile-guided-optimization for PostgreSQL JIT, to improve future JITed programs would be worthwhile. Difficulty would be when and for how long to to train, and how to deal with different workloads.
-
-
Replying to @AndresFreundTec
pg_ctl --volkswagen to detect benchmark runs?
1 reply 0 retweets 1 like -
Replying to @d_gustafsson
:P If we had caching (which we won't for v11), I'd say we count how often a certain expression is used and then start to instrument it after a threshold and collect profiling data *just* for that expression. And then optimize just that expression with PGO.
2 replies 0 retweets 1 like
Replying to @AndresFreundTec @d_gustafsson
Using global PGO data seems like it'd throw away a lot of benefit.
3:45 PM - 25 Mar 2018
0 replies
0 retweets
1 like
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.