- JIT compilation is in v11. Fuck yea. - 2 sentence: what's JIT - JIT compilation of expressions - when called from most places - JIT compilation of deforming - when called from within expressions - quick speedups - explain analyze (demo and showing JIT taking long) - generated IR - profiles - demonstration of problems: - JITed code is still a bottleneck - JITing can take quite a long while - CPU overhead - latency - Way forward - JIT more - COPY - sorts - main query execution - ... - JIT better - remove pointers - add more context - JIT caching - basic: local, remove pointers, hash IR, match on full binary comparison - improve: keep pointer to cache in prepared statement - improve: allow for shared cache - JIT startup: - JIT in the background, replace pointers