Date: 2024-09-30
Time: 12:00–12:50
Room: The Forum
Level: Intermediate
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 in augmenting PostgreSQL with machine learning. We will share valuable lessons learned while developing DBtune, a machine-learning-powered optimization service designed to unlock the full potential of your PostgreSQL instance.