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

Publikation: Beitrag in Buch/Konferenzbericht/Sammelband/GutachtenBeitrag in KonferenzbandBeigetragenBegutachtung

Beitragende

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

OriginalspracheEnglisch
TitelGvDB 2024 Grundlagen von Datenbanken 2024
Redakteure/-innenUta Störl
Seiten51-57
Seitenumfang7
PublikationsstatusVeröffentlicht - 2024
Peer-Review-StatusJa

Publikationsreihe

ReiheCEUR Workshop Proceedings
Band3710
ISSN1613-0073

Workshop

Titel35th Workshop on Foundations of Database Systems
KurztitelGvDB 2024
Veranstaltungsnummer35
Dauer22 - 24 Mai 2024
Webseite
OrtRinghotel Zweibrücker Hof Herdecke
StadtHerdecke
LandDeutschland

Externe IDs

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

Schlagworte

ASJC Scopus Sachgebiete

Schlagwörter

  • Optimizer Configuration, Query Optimization, Search Space Traversal