pgrust 表示其 JIT 在 5 微秒内为每个 SQL 查询编译代码

Michael Malis 和 Jason Seibel 通过 ARM64 模板绕过了 LLVM，这是一项狭窄的技术押注，可能使 JIT 在耗时较长的分析作业之外也变得有用。

By · Published

Primary source: malisper.me

为何重要

将 JIT 启动时间从大约 50 毫秒降至 5 微秒，可能会让编译执行适用于短查询，尽管 pgrust 仍需证明其正确性与可移植性。

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.…

When you purchase through links in our articles, we may earn a small commission. This doesn’t affect our editorial independence.

Reader comments

Conversation for this story loads after sign-in.