pgrust JIT compiler compiles SQL queries in around 5μs using copy-and-patch
Why it matters — Traditional database JIT compilers rely on LLVM or C/C++ code generation, both of which have high compile times that limit when compilation is worthwhile. At 5μs, the compilation cost is low enough to apply JIT optimization to every query, including single-execution ones. The author also notes that AI assistance made directly targeting assembly far more approachable than historically expected.
↗