Better JIT for Postgres. Contribute to vladich/pg_jitter development by creating an account on GitHub.

Hacker News is a community-driven platform for sharing and discussing technology news, startups, and programming-related topics. Through user submissions and comments, Hacker News offers insights into emerging technology trends, industry developments, and entrepreneurial ventures. Readers can participate in discussions, share their insights, and stay informed about the latest advancements in technology and innovation.

Hacker News

pg_jitter is a lightweight JIT compilation provider for PostgreSQL that replaces the default LLVM-based JIT with three faster alternatives: sljit, AsmJit, and MIR. The standard LLVM JIT suffers from slow compilation times (tens to hundreds of milliseconds), making it impractical for OLTP workloads. pg_jitter achieves microsecond-level compilation times, making JIT viable for a much broader range of queries. sljit is the recommended default (5–25% faster than the interpreter, fastest compilation), AsmJit excels on wide-row/deform-heavy queries (up to 32% faster), and MIR offers the best portability. The extension supports PostgreSQL 14–18, requires no LLVM dependency, and allows runtime backend switching without a server restart. Currently beta-quality, it passes all standard Postgres regression tests.

GitHub - vladich/pg_jitter: Better JIT for Postgres