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: 11459
Venue: VLDB
Year: 2016
Pagerank: 5.5892885e-05
Overall Rank: 7,594 | 47.90%
DOI: 10.14778/3007263.3007271

Incoming Non-self Citations Over Time

Authors

1. Dennis Butterstein (University of Tübingen)
2. Torsten Grust (University of Tübingen)

BibTeX Citation

@article{butterstein_vldb16,
        title = {{Precision Performance Surgery for PostgreSQL: LLVM-based Expression Compilation, Just in Time}},
        author = {Butterstein, Dennis and Grust, Torsten},
        journal = {PVLDB},
        series = {{VLDB} '16},
        volume = {9},
        number = {13},
        pages = {1517--1528},
        doi = {10.14778/3007263.3007271},
        url = {https://doi.org/10.14778/3007263.3007271},
        year = {2016}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,488	How to Architect a Query Compiler, Revisited	2018	SIGMOD	8.5091578e-05
8,057	Architecting a Query Compiler for Spatial Workloads	2020	SIGMOD	5.4982831e-05
9,565	TreeToaster: Towards an IVM-Optimized Compiler	2021	SIGMOD	5.2528121e-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
14	MonetDB/X100: Hyper-Pipelining Query Execution	2005	CIDR	0.0006312782
23	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.00054886415

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	8,781	Fast Vector Search in PostgreSQL: A Decoupled Approach	2026	CIDR
2	9,756	Efficient Query Re-optimization with Judicious Subquery Selections	2023	SIGMOD
3	10,541	Scalable GPU Acceleration of Scalar Functions in Analytical Databases: Compilation, Benchmarking, and Optimization	2026	VLDB
4	2,488	How to Architect a Query Compiler, Revisited	2018	SIGMOD
5	10,108	An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL	2025	SIGMOD
6	7,809	Can Large Language Models Be Query Optimizer for Relational Databases?	2026	SIGMOD
7	11,708	Low-Latency Compilation of SQL Queries to Machine Code	2021	VLDB
8	534	Building Efficient Query Engines in a High-Level Language	2014	VLDB
9	4,452	Just-in-time compilation for SQL query processing	2013	VLDB
10	23	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB