Database Paper Browser

Back to papers

An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL

Summary: Comprehensive experimental study of PostgreSQL's optimizer core: statistics, cardinality estimation, cost model, and plan generation. It reveals cross-component interactions and offers guidance for optimizer research and engineering. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
7009
Venue
SIGMOD
Year
2025
Pagerank
4.2254157e-05
Overall Rank
9,959 | 30.79%
DOI
10.1145/3709659

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 50 of 53 cited papers.

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

Rank Cited Paper Year Venue Pagerank
1 Access Path Selection in a Relational Database Management System 1979 SIGMOD 0.0040465394
71 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059446482
203 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00034868567
329 Neo: A Learned Query Optimizer 2019 VLDB 0.00027301488
606 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00019251186
627 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00018959896
634 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00018844568
752 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00017138049
905 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00015423174
1,064 Analyzing Plan Diagrams of Database Query Optimizers 2005 VLDB 0.00014348262
1,104 Cardinality Estimation Done Right: Index-Based Join Sampling 2017 CIDR 0.0001398479
1,239 Selectivity Estimation for Range Predicates using Lightweight Models 2019 VLDB 0.00013091459
1,297 The Picasso Database Query Optimizer Visualizer 2010 VLDB 0.00012732768
1,344 Dynamic Programming Strikes Back 2008 SIGMOD 0.00012477274
1,638 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00011050093
1,699 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00010848882
1,727 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00010731889
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,364 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 8.955077e-05
2,769 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 8.1512848e-05
2,781 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 8.1282042e-05
3,269 Learned Cardinality Estimation: An In-depth Study 2022 SIGMOD 7.3026051e-05
3,345 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 7.1908499e-05
3,455 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 7.0760196e-05
3,492 Fauce: Fast and Accurate Deep Ensembles with Uncertainty for Cardinality Estimation 2021 VLDB 7.0435484e-05
3,729 Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection 2022 VLDB 6.8078013e-05
3,819 Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction 2022 VLDB 6.7267885e-05
3,924 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 6.6227223e-05
3,992 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 6.5519369e-05
4,352 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 6.2542257e-05
4,413 Robust Query Driven Cardinality Estimation under Changing Workloads 2023 VLDB 6.1989918e-05
4,464 LOGER: A Learned Optimizer towards Generating Efficient and Robust Query Execution Plans 2023 VLDB 6.1552798e-05
4,526 Simplicity Done Right for Join Ordering 2021 CIDR 6.1079584e-05
5,339 LEON: A New Framework for ML-Aided Query Optimization 2023 VLDB 5.5596755e-05
5,412 Kepler: Robust Learning for Faster Parametric Query Optimization 2023 SIGMOD 5.5200608e-05
5,639 Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server 2023 VLDB 5.3972261e-05
5,654 AutoSteer: Learned Query Optimization for Any SQL Database 2023 VLDB 5.3882121e-05
5,886 COMPASS: Online Sketch-based Query Optimization for In-Memory Databases 2021 SIGMOD 5.2847297e-05
5,931 FASTgres: Making Learned Query Optimizer Hinting Effective 2023 VLDB 5.2632167e-05
5,978 SafeBound: A Practical System for Generating Cardinality Bounds 2023 SIGMOD 5.2424396e-05
6,639 Leveraging Query Logs and Machine Learning for Parametric Query Optimization 2022 VLDB 4.976781e-05
7,011 Simple Adaptive Query Processing vs. Learned Query Optimizers: Observations and Analysis 2023 VLDB 4.8583284e-05
7,220 Speeding Up End-to-end Query Execution via Learning-based Progressive Cardinality Estimation 2023 SIGMOD 4.7926382e-05
7,326 Lemo: A Cache-Enhanced Learned Optimizer for Concurrent Queries 2023 SIGMOD 4.7563708e-05
7,742 Rethinking Learned Cost Models: Why Start from Scratch? 2023 SIGMOD 4.6585812e-05
8,149 Efficiently Computing Join Orders with Heuristic Search 2023 SIGMOD 4.5715614e-05
8,621 A Study of Database Performance Sensitivity to Experiment Settings 2022 VLDB 4.4787515e-05
9,107 BASE: Bridging the Gap between Cost and Latency for Query Optimization 2023 VLDB 4.3907944e-05
9,628 Approximate Sketches 2024 SIGMOD 4.3102157e-05
Previous Page 1 / 2 Next

Semantically Similar Papers