Precision Performance Surgery for PostgreSQL: LLVM-based Expression Compilation, Just in Time

Summary: LLVM-based JIT compiles SQL expressions to native x86 code in PostgreSQL 9, enabling runtime speedups for arithmetic and filter expressions. Non-invasive design coexists with interpretation, yielding substantial savings and providing visibility into plan regions that benefit from expression compilation. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 11271
Venue: VLDB
Year: 2016
Pagerank: 4.6806834e-05
Overall Rank: 7,679 | 46.58%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Dennis Butterstein
2. Torsten Grust

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,838	How to Architect a Query Compiler, Revisited	2018	SIGMOD	8.0408472e-05
7,925	Architecting a Query Compiler for Spatial Workloads	2020	SIGMOD	4.6153403e-05
9,414	TreeToaster: Towards an IVM-Optimized Compiler	2021	SIGMOD	4.3441378e-05

Outgoing Citations (Sorted by Pagerank)

Showing 2 of 2 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
35	MonetDB/X100: Hyper-Pipelining Query Execution	2005	CIDR	0.00076197749
60	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.00064439773

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
9,978	Fast Vector Search in PostgreSQL: A Decoupled Approach	2026	CIDR	4.1945683e-05
9,662	Efficient Query Re-optimization with Judicious Subquery Selections	2023	SIGMOD	4.3097631e-05
10,253	Scalable GPU Acceleration of Scalar Functions in Analytical Databases: Compilation, Benchmarking, and Optimization	2026	VLDB	4.1945683e-05
2,838	How to Architect a Query Compiler, Revisited	2018	SIGMOD	8.0408472e-05
9,960	An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL	2025	SIGMOD	4.2294678e-05
8,488	Can Large Language Models Be Query Optimizer for Relational Databases?	2026	SIGMOD	4.4998609e-05
11,510	Low-Latency Compilation of SQL Queries to Machine Code	2021	VLDB	4.1945683e-05
704	Building Efficient Query Engines in a High-Level Language	2014	VLDB	0.00017900583
60	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.00064439773
4,376	Just-in-time compilation for SQL query processing	2013	VLDB	6.2424797e-05