Autotuning PostgreSQL on Azure Flexible Server | POSETTE 2024

From the creator

Video of a conference talk about autotuning PostgreSQL presented by Luigi Nardi at POSETTE: An Event for Postgres 2024. We'll explore the intricate world of PostgreSQL parameter tuning, where the database management system reveals a multitude of configurable parameters that govern its runtime behavior. As the system evolves, the increasing number, the non-linear relationship and the complexity of these parameters highlight the importance of their correct configuration in optimizing application performance and cloud resource utilization. This talk delves into various tuning approaches. We'll start with the traditional, meticulous method of manual tuning, relying on expert analysis of metrics like query response times and resource usage. We'll then explore heuristic-based tools like PGTune and PostgreSQL Configurator, offering one-size-fits-all solutions. Finally, we'll set our sights on the future: auto-tuning with machine learning. We'll showcase how these more sophisticated methods can be customized to a specific workload and machine resources. We'll highlight the challenges and the advantages of transforming PostgreSQL into a more self-driving database management system and show a proof-of-concept on auto-tuning PostgreSQL Azure Flexible Server with some preliminary performance results. Luigi is the founder and CEO of DBtune (www.dbtune.com), a leading company driving advancements in AI, database systems, and cloud computing. Previously an associate professor of machine

Published 2024-06-13 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.