Steering the PostgreSQL query optimizer using hinting: State-Of-The-Art and open challenges
Research output: Contribution to book/Conference proceedings/Anthology/Report › Conference contribution › Contributed › peer-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 language | English |
|---|---|
| Title of host publication | GvDB 2024 Grundlagen von Datenbanken 2024 |
| Editors | Uta Störl |
| Pages | 51-57 |
| Number of pages | 7 |
| Publication status | Published - 2024 |
| Peer-reviewed | Yes |
Publication series
| Series | CEUR Workshop Proceedings |
|---|---|
| Volume | 3710 |
| ISSN | 1613-0073 |
Workshop
| Title | 35th Workshop on Foundations of Database Systems |
|---|---|
| Abbreviated title | GvDB 2024 |
| Conference number | 35 |
| Duration | 22 - 24 May 2024 |
| Website | |
| Location | Ringhotel Zweibrücker Hof Herdecke |
| City | Herdecke |
| Country | Germany |
External IDs
| ORCID | /0000-0001-8107-2775/work/194824073 |
|---|
Keywords
ASJC Scopus subject areas
Keywords
- Optimizer Configuration, Query Optimization, Search Space Traversal