Steering the PostgreSQL query optimizer using hinting: State-Of-The-Art and open challenges
Publikation: Beitrag in Buch/Konferenzbericht/Sammelband/Gutachten › Beitrag in Konferenzband › Beigetragen › Begutachtung
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
| Originalsprache | Englisch |
|---|---|
| Titel | GvDB 2024 Grundlagen von Datenbanken 2024 |
| Redakteure/-innen | Uta Störl |
| Seiten | 51-57 |
| Seitenumfang | 7 |
| Publikationsstatus | Veröffentlicht - 2024 |
| Peer-Review-Status | Ja |
Publikationsreihe
| Reihe | CEUR Workshop Proceedings |
|---|---|
| Band | 3710 |
| ISSN | 1613-0073 |
Workshop
| Titel | 35th Workshop on Foundations of Database Systems |
|---|---|
| Kurztitel | GvDB 2024 |
| Veranstaltungsnummer | 35 |
| Dauer | 22 - 24 Mai 2024 |
| Webseite | |
| Ort | Ringhotel Zweibrücker Hof Herdecke |
| Stadt | Herdecke |
| Land | Deutschland |
Externe IDs
| ORCID | /0000-0001-8107-2775/work/194824073 |
|---|
Schlagworte
ASJC Scopus Sachgebiete
Schlagwörter
- Optimizer Configuration, Query Optimization, Search Space Traversal