FASTgres: Making Learned Query Optimizer Hinting Effective

Summary: FASTgres uses context-aware learned classification to predict effective PostgreSQL optimizer hint sets, rather than replacing the cost model or optimizer. Across benchmarks and PostgreSQL versions, it delivers transparent, consistent gains—up to 3.25× lower runtime—by steering plan selection. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 13355
Venue: VLDB
Year: 2023
Pagerank: 6.2859099e-05
Overall Rank: 5,277 | 63.80%
DOI: 10.14778/3611479.3611528

Incoming Non-self Citations Over Time

Authors

1. Lucas Woltmann (Technical University of Dresden)
2. Jerome Thiessat (Technical University of Dresden)
3. Claudio Hartmann (Technical University of Dresden)
4. Dirk Habich (Technical University of Dresden)
5. Wolfgang Lehner (Technical University of Dresden)

BibTeX Citation

@article{woltmann_vldb23,
        title = {{FASTgres: Making Learned Query Optimizer Hinting Effective}},
        author = {Woltmann, Lucas and Thiessat, Jerome and Hartmann, Claudio and Habich, Dirk and Lehner, Wolfgang},
        journal = {PVLDB},
        series = {{VLDB} '23},
        volume = {16},
        number = {11},
        pages = {3310--3322},
        doi = {10.14778/3611479.3611528},
        url = {https://doi.org/10.14778/3611479.3611528},
        year = {2023}
}

Incoming Citations (Sorted by Pagerank)

Showing 13 of 13 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
5,107	Stage: Query Execution Time Prediction in Amazon Redshift	2024	SIGMOD	6.3623786e-05
7,846	The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions	2024	VLDB	5.5331459e-05
9,601	Low Rank Learning for Offline Query Optimization	2025	SIGMOD	5.2487799e-05
9,626	Spatial Query Optimization With Learning	2024	VLDB	5.2434488e-05
9,920	Still Asking: How Good Are Query Optimizers, Really?	2025	VLDB	5.1955087e-05
10,108	An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL	2025	SIGMOD	5.1347137e-05
10,316	GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints	2026	SIGMOD	5.093636e-05
10,401	SEFRQO: A Self-Evolving Fine-Tuned RAG-Based Query Optimizer	2026	SIGMOD	5.093636e-05
10,445	Divo: Learning a Stable and Effective Query Optimizer with a Diverse Workload	2026	SIGMOD	5.093636e-05
10,492	Reqo: A Comprehensive Learning-Based Cost Model for Robust and Explainable Query Optimization	2026	SIGMOD	5.093636e-05
10,508	Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking	2026	SIGMOD	5.093636e-05
10,513	LIO: A lightweight and interpretable query optimizer based on an evolutionary forest	2026	VLDB	5.093636e-05
10,586	TATA: An Efficient Framework for Task Transfer in Query Plan Representation	2026	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 19 of 19 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
18	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059284255
84	Learned Cardinalities: Estimating Correlated Joins with Deep Learning	2019	CIDR	0.00035838391
100	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00034385207
154	Neo: A Learned Query Optimizer	2019	VLDB	0.00028726181
290	An Overview of Query Optimization in Relational Systems	1998	PODS	0.0002227038
378	Bao: Making Learned Query Optimization Practical	2021	SIGMOD	0.00019638121
465	An End-to-End Learning-based Cost Estimator	2020	VLDB	0.0001803934
694	Cardinality Estimation Done Right: Index-Based Join Sampling	2017	CIDR	0.00014911698
802	Random Sampling over Joins Revisited	2018	SIGMOD	0.00013907725
1,241	Balsa: Learning a Query Optimizer Without Expert Demonstrations	2022	SIGMOD	0.00011521639
1,499	Pessimistic Cardinality Estimation: Tighter Upper Bounds for Intermediate Join Cardinalities	2019	SIGMOD	0.00010564536
1,664	Two-Level Sampling for Join Size Estimation	2017	SIGMOD	0.00010070362
2,762	Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection	2022	VLDB	8.1539867e-05
2,944	Query Optimizers: Time to Rethink the Contract?	2009	SIGMOD	7.9335187e-05
3,213	Estimating Cardinalities with Deep Sketches	2019	SIGMOD	7.6328677e-05
3,959	Simplicity Done Right for Join Ordering	2021	CIDR	6.9879431e-05
4,900	COMPASS: Online Sketch-based Query Optimization for In-Memory Databases	2021	SIGMOD	6.4534715e-05
8,183	alpha to omega: The Greek Alphabet of Sampling	2020	CIDR	5.4714466e-05
10,016	Turbo-Charging SPJ Query Plans with Learned Physical Join Operator Selections	2022	VLDB	5.1764556e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	11,103	RankPQO: Learning-to-Rank for Parametric Query Optimization	2025	VLDB
2	11,290	Presto’s History-based Query Optimizer	2024	VLDB
3	9,971	Athena: An Effective Learning-based Framework for Query Optimizer Performance Improvement	2025	SIGMOD
4	8,163	Learned Offline Query Planning via Bayesian Optimization	2025	SIGMOD
5	7,448	Interactive Plan Hints for Query Optimization	2009	SIGMOD
6	11,035	Hint-QPT: Hints for Robust Query Performance Tuning	2025	VLDB
7	9,756	Efficient Query Re-optimization with Judicious Subquery Selections	2023	SIGMOD
8	4,929	AutoSteer: Learned Query Optimization for Any SQL Database	2023	VLDB
9	6,543	Speeding Up End-to-end Query Execution via Learning-based Progressive Cardinality Estimation	2023	SIGMOD
10	2,762	Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection	2022	VLDB