Back to papers
FASTgres: Making Learned Query Optimizer Hinting Effective
Summary: Introduces FASTgres, a learning-based context-aware classifier that predicts transparent, direct hint sets to steer PostgreSQL’s cost-based optimizer instead of replacing it. Demonstrates consistent end-to-end speedups up to 3.25× across benchmarks.
(summarized by gpt-5-mini on Feb 09 2026)
- Paper ID
- 13168
- Venue
- VLDB
- Year
- 2023
- Pagerank
- 5.2632167e-05
- Overall Rank
- 5,931 | 58.79%
- DOI
-
10.14778/3611479.3611528
Incoming Non-self Citations Over Time
Incoming Citations (Sorted by Pagerank)
Showing 13 of 13 citing papers.
| Rank |
Citing Paper |
Year |
Venue |
Pagerank |
| 5,844 |
Stage: Query Execution Time Prediction in Amazon Redshift |
2024 |
SIGMOD |
5.3060581e-05 |
| 8,003 |
The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions |
2024 |
VLDB |
4.6049527e-05 |
| 9,487 |
Spatial Query Optimization With Learning |
2024 |
VLDB |
4.3300131e-05 |
| 9,581 |
Low Rank Learning for Offline Query Optimization |
2025 |
SIGMOD |
4.3186744e-05 |
| 9,746 |
Still Asking: How Good Are Query Optimizers, Really? |
2025 |
VLDB |
4.2856385e-05 |
| 9,959 |
An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL |
2025 |
SIGMOD |
4.2254157e-05 |
| 10,018 |
GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints |
2026 |
SIGMOD |
4.1905499e-05 |
| 10,112 |
SEFRQO: A Self-Evolving Fine-Tuned RAG-Based Query Optimizer |
2026 |
SIGMOD |
4.1905499e-05 |
| 10,156 |
Divo: Learning a Stable and Effective Query Optimizer with a Diverse Workload |
2026 |
SIGMOD |
4.1905499e-05 |
| 10,203 |
Reqo: A Comprehensive Learning-Based Cost Model for Robust and Explainable Query Optimization |
2026 |
SIGMOD |
4.1905499e-05 |
| 10,219 |
Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking |
2026 |
SIGMOD |
4.1905499e-05 |
| 10,225 |
LIO: A lightweight and interpretable query optimizer based on an evolutionary forest |
2026 |
VLDB |
4.1905499e-05 |
| 10,300 |
TATA: An Efficient Framework for Task Transfer in Query Plan Representation |
2026 |
VLDB |
4.1905499e-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 |
| 71 |
How Good Are Query Optimizers, Really? |
2016 |
VLDB |
0.00059446482 |
| 181 |
LEO - DB2's LEarning Optimizer |
2001 |
VLDB |
0.00036970794 |
| 203 |
Learned Cardinalities: Estimating Correlated Joins with Deep Learning |
2019 |
CIDR |
0.00034868567 |
| 329 |
Neo: A Learned Query Optimizer |
2019 |
VLDB |
0.00027301488 |
| 454 |
An Overview of Query Optimization in Relational Systems |
1998 |
PODS |
0.00022796106 |
| 634 |
Bao: Making Learned Query Optimization Practical |
2021 |
SIGMOD |
0.00018844568 |
| 804 |
An End-to-End Learning-based Cost Estimator |
2020 |
VLDB |
0.0001643674 |
| 1,104 |
Cardinality Estimation Done Right: Index-Based Join Sampling |
2017 |
CIDR |
0.0001398479 |
| 1,372 |
Random Sampling over Joins Revisited |
2018 |
SIGMOD |
0.0001233325 |
| 2,090 |
Balsa: Learning a Query Optimizer Without Expert Demonstrations |
2022 |
SIGMOD |
9.5668285e-05 |
| 2,143 |
Pessimistic Cardinality Estimation: Tighter Upper Bounds for Intermediate Join Cardinalities |
2019 |
SIGMOD |
9.4437798e-05 |
| 2,254 |
Two-Level Sampling for Join Size Estimation |
2017 |
SIGMOD |
9.1871115e-05 |
| 3,402 |
Query Optimizers: Time to Rethink the Contract? |
2009 |
SIGMOD |
7.134261e-05 |
| 3,725 |
Estimating Cardinalities with Deep Sketches |
2019 |
SIGMOD |
6.8117015e-05 |
| 3,729 |
Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection |
2022 |
VLDB |
6.8078013e-05 |
| 4,526 |
Simplicity Done Right for Join Ordering |
2021 |
CIDR |
6.1079584e-05 |
| 5,886 |
COMPASS: Online Sketch-based Query Optimization for In-Memory Databases |
2021 |
SIGMOD |
5.2847297e-05 |
| 8,345 |
alpha to omega: The Greek Alphabet of Sampling |
2020 |
CIDR |
4.5361313e-05 |
| 9,868 |
Turbo-Charging SPJ Query Plans with Learned Physical Join Operator Selections |
2022 |
VLDB |
4.2634472e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 10,884 |
RankPQO: Learning-to-Rank for Parametric Query Optimization |
2025 |
VLDB |
4.1905499e-05 |
| 11,087 |
Presto’s History-based Query Optimizer |
2024 |
VLDB |
4.1905499e-05 |
| 9,824 |
Athena: An Effective Learning-based Framework for Query Optimizer Performance Improvement |
2025 |
SIGMOD |
4.2710095e-05 |
| 8,660 |
Learned Offline Query Planning via Bayesian Optimization |
2025 |
SIGMOD |
4.4680058e-05 |
| 7,438 |
Interactive Plan Hints for Query Optimization |
2009 |
SIGMOD |
4.7256896e-05 |
| 10,813 |
Hint-QPT: Hints for Robust Query Performance Tuning |
2025 |
VLDB |
4.1905499e-05 |
| 9,662 |
Efficient Query Re-optimization with Judicious Subquery Selections |
2023 |
SIGMOD |
4.3056334e-05 |
| 5,654 |
AutoSteer: Learned Query Optimization for Any SQL Database |
2023 |
VLDB |
5.3882121e-05 |
| 7,220 |
Speeding Up End-to-end Query Execution via Learning-based Progressive Cardinality Estimation |
2023 |
SIGMOD |
4.7926382e-05 |
| 3,729 |
Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection |
2022 |
VLDB |
6.8078013e-05 |