pg_jitter: Lightweight JIT Compilation Provider for PostgreSQL with Alternative Backends
By
vladich
Baker's choice. Dense with flavour, light on filler.
Summary
pg_jitter is a lightweight JIT compilation provider for PostgreSQL that offers three alternative JIT backends (sljit, AsmJit, and MIR) as alternatives to the standard LLVM-based JIT. It aims to provide faster compilation times and competitive query execution performance for PostgreSQL versions 14-18, particularly benefiting expression-heavy workloads and wide tables where JIT compilation can significantly improve performance by reducing interpretation overhead and inefficient per-row loops.
Key quotes
· 3 pulledA lightweight JIT compilation provider for PostgreSQL that adds three alternative JIT backends - sljit, AsmJit and MIR - delivering faster compilation and competitive query execution across PostgreSQL 14–18.
JIT compilation was introduced in Postgres 11 in 2018. It solves a problem of Postgres having to interpret expressions and use inefficient per-row loops in run-time in order to do internal data conversions (so-called tuple deforming).
On expression-heavy workloads or just wide tables, it can give a significant performance boost for those operations.
You might also wanna read
GitGres: A PostgreSQL-based private GitHub reimplementation for teams
GitGres is an open-source project that provides a starting point for private, PostgreSQL-based reimplementations of GitHub, optimized for in
github.com·1mo ago
pgBackRest Project Discontinued After 13 Years of Development
The creator of pgBackRest, a popular open-source PostgreSQL backup and restore tool, announces that the project is no longer being maintaine
github.com·1mo ago
SQLite Graph Extension: Adding Graph Database Capabilities to SQLite
sqlite-graph is an alpha-release SQLite extension that adds graph database capabilities with Cypher query support, allowing users to work wi
github.com·7mo ago
pgstream: Open Source PostgreSQL Replication Tool with DDL Change Support
pgstream is an open-source command-line tool and library that provides PostgreSQL replication with support for DDL (Data Definition Language
github.com·8mo ago
Netflix engineer's open-source tool cuts AI token usage by up to 90%
Netflix senior engineer Tejas Chopra created software called "Project Headroom" that prunes redundant tokens from AI agent instructions befo
theregister.com·9h ago
Copyparty: A Lightweight File Server That Runs as a Single Python Script
Copyparty is a lightweight, full-featured file server that runs as a single Python script, making it extremely easy to set up without needin
hackaday.com·11h ago