Title
PgCuckoo: Laying Plan Eggs in PostgreSQL's Nest
Abstract
We demonstrate how to use PostgreSQL's planner hook to open a side entrance through which we can pass plan trees for immediate execution. Since this reaches deep into PostgreSQL, we implement plan detail inference and decoration to ensure that externally crafted trees perfectly mimic regular plans. Plan trees may then (1) be generated by external code generators that want to use PostgreSQL as a reliable and efficient back-end for new (maybe even non-relational) languages, or (2) stem from experimental rewrites of SQL plans that PostgreSQL itself does not implement (yet). The demonstration provides a live account of what becomes possible once we let PostgreSQL hatch foreign plan eggs.
Year
DOI
Venue
2019
10.1145/3299869.3320211
Proceedings of the 2019 International Conference on Management of Data
Keywords
Field
DocType
code generation, plan injection, plan stitching, postgresql
Computer science,Laying,Nest,Database
Conference
ISSN
ISBN
Citations 
0730-8078
978-1-4503-5643-5
0
PageRank 
References 
Authors
0.34
0
2
Name
Order
Citations
PageRank
Denis Hirn101.69
Torsten Grust21482148.79