pgrust says its JIT compiles code for every SQL query in 5 microseconds

Michael Malis and Jason Seibel bypassed LLVM with ARM64 stencils, a narrow technical bet that could make JIT useful beyond long analytics jobs.

By · Published

Primary source: malisper.me

Why it matters

Cutting JIT startup from about 50 milliseconds to 5 microseconds could bring compiled execution to short queries, though pgrust still has to prove correctness and portability.

pgrust says its JIT compiles each SQL query in 5 microseconds — Michael Malis and Jason Seibel bypassed LLVM with ARM64 stencils, a narrow technical bet that could make JIT useful beyond long analytics jobs.

Michael Malis (@mmalisper) and Jason Seibel (@JasonSeibel) built pgrust, whose JIT compiler generates query-specific machine code in roughly 5 microseconds, according to Malis. That is fast enough for pgrust to compile every SQL query before executing it.…

Reader comments

Conversation for this story loads after sign-in.