Steering the PostgreSQL query optimizer using hinting: State-Of-The-Art and open challenges

Research output: Contribution to book/Conference proceedings/Anthology/ReportConference contributionContributedpeer-review

Contributors

Abstract

In the field of query optimization, a tremendous amount of research has been delivered into fixing and adjusting existing optimizer solutions. Moreover, recent work has also shown that substantial performance gain can be achieved by setting query optimizer instructions appropriately. However, the sets of beneficial instructions may vary greatly for each query. In this contribution, we provide a state-of-the-art review on optimizer hinting and present some experimental evaluations showing hints should not be neglected during evaluation based on preliminary assumptions.

Details

Original languageEnglish
Title of host publicationGvDB 2024 Grundlagen von Datenbanken 2024
EditorsUta Störl
Pages51-57
Number of pages7
Publication statusPublished - 2024
Peer-reviewedYes

Publication series

SeriesCEUR Workshop Proceedings
Volume3710
ISSN1613-0073

Workshop

Title35th Workshop on Foundations of Database Systems
Abbreviated titleGvDB 2024
Conference number35
Duration22 - 24 May 2024
Website
LocationRinghotel Zweibrücker Hof Herdecke
CityHerdecke
CountryGermany

External IDs

ORCID /0000-0001-8107-2775/work/194824073

Keywords

ASJC Scopus subject areas

Keywords

  • Optimizer Configuration, Query Optimization, Search Space Traversal