Optimizing Query Processing in PostgreSQL Through Learned Optimizer Hints

J Thiessat, L Woltmann, C Hartmann, D Habich - BTW 2023, 2023 - dl.gi.de
BTW 2023, 2023dl.gi.de
Query optimization in database systems is an important aspect and despite decades of
research, it isstill far from being solved. Nowadays, query optimizers usually provide hints to
be able to steer theoptimization on a query-by-query basis. However, setting the best-fitting
hints is challenging. To tacklethat, we present a learning-based approach to predict the best-
fitting hints for each incoming query. Inparticular, our learning approach is based on simple
gradient boosting, where we learn one modelper query context for fine-grained predictions …
Zusammenfassung
Query optimization in database systems is an important aspect and despite decades of research, it isstill far from being solved. Nowadays, query optimizers usually provide hints to be able to steer theoptimization on a query-by-query basis. However, setting the best-fitting hints is challenging. To tacklethat, we present a learning-based approach to predict the best-fitting hints for each incoming query. Inparticular, our learning approach is based on simple gradient boosting, where we learn one modelper query context for fine-grained predictions rather than a single global context-agnostic model asproposed in related work. We demonstrate the efficiency as well as effectiveness of our learning-basedapproach using the open-source database system PostgreSQL and show that our approach outperformsrelated work in that context.
dl.gi.de
Showing the best result for this search. See all results