Proc. ACM Manag. Data, Vol. 4, No. 1 (SIGMOD), Article 90. Publication date: February 2026.
William Zhang, Wan Shen Lim, Andrew Pavlo
Carnegie Mellon University
Tuning database management systems (DBMSs) is challenging due to trillions of possible configurations andevolving workloads. Recent advances in tuning have led to breakthroughs in optimizing over the possibleconfigurations. However, due to their design and inability to leverage query-level historical insights, existingautomated tuners struggle to adapt and re-optimize the DBMS when the environment changes (e.g., workloaddrift, schema transfer).This paper presents the Booster framework that assists existing tuners in adapting to environment changes(e.g., drift, cross-schema transfer). Booster structures historical artifacts into query-configuration contexts,prompts large language models (LLMs) to suggest configurations for each query based on relevant contexts,and then composes the query-level suggestions into a holistic configuration with beam search. With multipleOLAP workloads, we evaluate Booster’s ability to assist different state-of-the-art tuners (e.g., cost-/machinelearning-/LLM-based) in adapting to environment changes. By composing recommendations derived fromquery-level insights, Booster assists tuners in discovering configurations that are up to 74% better and in upto 4.7× less time than the alternative approach of continuing to tune from historical configurations.
FULL PAPER: pdf