vladich

vladich / pg_jitter

Public

Better JIT for Postgres

72
1
100% credibility
Found Mar 04, 2026 at 72 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
C
AI Summary

A PostgreSQL extension offering faster just-in-time compilation alternatives to the default LLVM backend using lightweight libraries for quicker query processing.

How It Works

1
🔍 Discover faster database queries

You hear about pg_jitter, a tool that makes your PostgreSQL database think quicker on heavy workloads.

2
📦 Gather simple helpers

Place a few small helper libraries next to the pg_jitter folder, like puzzle pieces ready to fit together.

3
🔨 Build with one click

Run a simple build script to prepare everything, watching it create speedy helpers in seconds.

4
🚀 Install into your database

Use the install script to add the helpers to your running database and restart it gently.

5
⚙️ Turn on smart mode

In your database settings, pick a helper like sljit and reload—your queries now think faster without changing code.

⚡ Enjoy blazing queries

Your database handles more work smoothly, with queries finishing quicker and your apps feeling snappier.

Sign up to see the full architecture

4 more

Sign Up Free

Star Growth

See how this repo grew from 72 to 72 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is pg_jitter?

pg_jitter is a drop-in JIT provider for PostgreSQL 14-18 that replaces the default LLVM backend with faster alternatives like sljit, AsmJit, and MIR, written in C. It cuts compilation from milliseconds to microseconds, making JIT viable for OLTP queries on wide tables where tuple deforming drags down performance. Users get 5-32% speedups via simple config: set `jit_provider = 'pg_jitter_sljit'` and tweak `jit_above_cost` to 200-1000.

Why is it gaining traction?

Unlike LLVM's heavy startup lag, pg_jitter compiles in tens of microseconds and beats the interpreter consistently, especially on deform-heavy workloads—better than jitter for everyday queries. Zero LLVM dependency, runtime backend switching without restarts, and detailed ARM64/x86 benchmarks hook perf obsessives tired of OLAP-only JIT wins. It's portable across Linux/MacOS, with build scripts that just work alongside sibling dirs for backends.

Who should use this?

Postgres admins tuning OLTP apps with wide-row scans or aggregations on expression-heavy tables. Devs benchmarking PG 14-18 who hit LLVM compile overhead exceeding query time. Teams dodging better xcloud jitter or seeking better than Jitsi-like latency in database hotspots.

Verdict

Try it for perf-critical Postgres if you're on supported versions—benchmarks prove real gains, and setup is straightforward. At 72 stars and 1.0% credibility, it's beta-quality (passes regressions, no production scale yet), so test thoroughly before prod.

(198 words)

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.