The Building Blocks for Self-Driving PostgreSQL | Citus Con: An Event for Postgres 2022 Keynote

From the creator

Video of a keynote talk presented by Andy Pavlo of CMUDB at Citus Con: An Event for Postgres. Abstract: Over the last 50 years, people have built advisory tools to assist in all aspects of database tuning and optimization. Most of this work is incomplete because it requires humans to make decisions about changes to the database—plus the tools are reactive, fixing problems only after they occur. A “self-driving” database aims to overcome these limitations by anticipating future workload trends, automatically deploying optimizations without human intervention, and learning from its environment to handle new situations. And a self-driving database can be optimized in ways that are not possible today, because the complexity of databases has surpassed the abilities of human experts. In this talk during the Americas livestream at Citus Con, Andy Pavlo covers state-of-the-art in autonomous DBMSs—namely what is possible today and what problems remain—as well as the efforts at Carnegie Mellon to build a true self-driving DBMS in the NoisePage and OtterTune projects. We’ll then explore how PostgreSQL already has most of the instrumentation and extension hooks needed to control its runtime behavior via ML-based planning components. We’ll finish with Andy’s “wish-list” of features for PostgreSQL—the building blocks—that can help to bring self-driving PostgreSQL closer to reality. Andy Pavlo is an Associate Professor of Databaseology in the Computer Science Department at Carnegie Mellon

Published 2022-04-26 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.