Origins of OtterTune, The problem with knob tuning, Roles of machine learning, The challenges of database tuning and the role of human expertise, Tuning in production, Observability and Data Collection Data Security and Privacy, Optimizing on-prem vs. cloud workloads Performance benchmarks, Importance of automated tuning services, Challenges in Benchmarking Real Workloads, The Story Behind the Name OtterTune, Balancing Technology and Human Factors

Andy Pavlo, discusses how his introduction to “databaseology” changed the way databases are not only built but also studied for more efficiency at companies. From optimizing databases for efficient testing and usage to building effective databases using the right knobs and building blocks, Andy shares his insights and expertise on how to improve the performance and reliability of your applications.

How confident are you that your database is configured to be as performant as possible? In this episode, Andy Pavlo who researches autonomous database systems, explains the challenges of tuning databases and introduces us to OtterTune, a tuning service created out of his research.