EUVIMEDEUVIMED entdecken
Crossref

FASTgres: Making Learned Query Optimizer Hinting Effective

Lucas Woltmann, Jerome Thiessat, Claudio Hartmann, Dirk Habich, Wolfgang Lehner

Proceedings of the VLDB Endowment · 2023-07 · 16 (11) · 3310-3322

DOI: 10.14778/3611479.3611528 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Proceedings of the VLDB Endowment, online erschienen am 24.08.2023. Verfasst von Lucas Woltmann und 4 weiteren Autor:innen. Die Arbeit wurde bisher 43-mal zitiert (Crossref) und nennt 33 Literaturangaben.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

The traditional and well-established cost-based query optimizer approach enumerates different execution plans for each query, assesses each plan with costs, and selects the plan that promises the lowest costs for execution. However, the optimal execution plan is not always selected. To steer the optimizer in the right direction, many query optimizers provide configuration parameters called query optimizer hints. These hints can be set for every single query separately. To show the great potential of these hints for the optimization of analytical queries, we present results of a comprehensive and in-depth evaluation using three benchmarks and two different versions of the open-source database system PostgreSQL. In particular, we highlight that query optimizer hinting is a non-trivial challenge. To solve this challenge, we propose FASTgres , a learning-based context-aware classification strategy for hint set prediction. Compared to related work, FASTgres provides transparent and direct hint set predictions with consistent performance improvements. In our end-to-end evaluation, we demonstrate that FASTgres effectively reduces benchmark runtimes by a factor of up to 3.25x with only steering the cost-based optimizer.

Zitieren

APA

Woltmann, L., Thiessat, J., Hartmann, C., Habich, D., & Lehner, W. (2023). FASTgres: Making Learned Query Optimizer Hinting Effective. Proceedings of the VLDB Endowment, 16(11), 3310-3322. https://doi.org/10.14778/3611479.3611528

Vancouver

Woltmann L, Thiessat J, Hartmann C, Habich D, Lehner W. FASTgres: Making Learned Query Optimizer Hinting Effective. Proceedings of the VLDB Endowment. 2023;16(11):3310-3322. doi:10.14778/3611479.3611528

BibTeX
@article{Woltmann2023,
  author = {Woltmann, Lucas and Thiessat, Jerome and Hartmann, Claudio and Habich, Dirk and Lehner, Wolfgang},
  title = {FASTgres: Making Learned Query Optimizer Hinting Effective},
  journal = {Proceedings of the VLDB Endowment},
  year = {2023},
  volume = {16},
  number = {11},
  pages = {3310--3322},
  doi = {10.14778/3611479.3611528}
}
Kostenlos starten →