Konferenzbeitrag
Optimizing Query Processing in PostgreSQL Through Learned Optimizer Hints
Vorschaubild nicht verfügbar
Volltext URI
Dokumententyp
Text/Conference Paper
Dateien
Zusatzinformation
Datum
2023
Autor:innen
Zeitschriftentitel
ISSN der Zeitschrift
Bandtitel
Quelle
Verlag
Gesellschaft für Informatik e.V.
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.