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: ha98446d9b6583d9c
Venue: VLDB
Year: 2023
Pagerank: 6.1995935e-05
Overall Rank: 5,245 | 64.85%
DOI: 10.14778/3611479.3611528
PDF: Download (CC BY-NC-ND 4.0)

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 14 of 14 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
4,833	Stage: Query Execution Time Prediction in Amazon Redshift	2024	SIGMOD	6.3834856e-05
7,997	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.3938336e-05
8,389	GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints	2026	SIGMOD	5.3250456e-05
8,908	Spatial Query Optimization With Learning	2024	VLDB	5.2369727e-05
9,662	Low Rank Learning for Offline Query Optimization	2025	SIGMOD	5.1283524e-05
10,143	Still Asking: How Good Are Query Optimizers, Really?	2025	VLDB	5.0597449e-05
10,370	An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL	2025	SIGMOD	5.0010514e-05
10,668	SEFRQO: A Self-Evolving Fine-Tuned RAG-Based Query Optimizer	2026	SIGMOD	4.9605343e-05
10,705	Divo: Learning a Stable and Effective Query Optimizer with a Diverse Workload	2026	SIGMOD	4.9605343e-05
10,751	Reqo: A Comprehensive Learning-Based Cost Model for Robust and Explainable Query Optimization	2026	SIGMOD	4.9605343e-05
10,764	Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking	2026	SIGMOD	4.9605343e-05
10,769	LIO: A lightweight and interpretable query optimizer based on an evolutionary forest	2026	VLDB	4.9605343e-05
10,994	TATA: An Efficient Framework for Task Transfer in Query Plan Representation	2026	VLDB	4.9605343e-05
11,011	Ultron: History-Based Query Optimization at Databricks	2026	VLDB	4.9605343e-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
15	How Good Are Query Optimizers, Really?	2016	VLDB	0.00061463175
84	Learned Cardinalities: Estimating Correlated Joins with Deep Learning	2019	CIDR	0.00035920657
98	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00034050614
142	Neo: A Learned Query Optimizer	2019	VLDB	0.00029114937
259	An Overview of Query Optimization in Relational Systems	1998	PODS	0.00022881075
355	Bao: Making Learned Query Optimization Practical	2021	SIGMOD	0.00020146245
453	An End-to-End Learning-based Cost Estimator	2020	VLDB	0.0001801482
689	Cardinality Estimation Done Right: Index-Based Join Sampling	2017	CIDR	0.00014725904
793	Random Sampling over Joins Revisited	2018	SIGMOD	0.00013903938
1,175	Balsa: Learning a Query Optimizer Without Expert Demonstrations	2022	SIGMOD	0.00011630532
1,444	Pessimistic Cardinality Estimation: Tighter Upper Bounds for Intermediate Join Cardinalities	2019	SIGMOD	0.00010616242
1,681	Two-Level Sampling for Join Size Estimation	2017	SIGMOD	9.8821344e-05
2,696	Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection	2022	VLDB	8.1068354e-05
2,888	Query Optimizers: Time to Rethink the Contract?	2009	SIGMOD	7.8895201e-05
3,282	Estimating Cardinalities with Deep Sketches	2019	SIGMOD	7.4491295e-05
3,995	Simplicity Done Right for Join Ordering	2021	CIDR	6.8530469e-05
5,029	COMPASS: Online Sketch-based Query Optimization for In-Memory Databases	2021	SIGMOD	6.2952031e-05
8,363	alpha to omega: The Greek Alphabet of Sampling	2020	CIDR	5.3305234e-05
10,249	Turbo-Charging SPJ Query Plans with Learned Physical Join Operator Selections	2022	VLDB	5.0412674e-05

Semantically Similar Papers

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