PostgreSQL performance is affected by dozens of configuration settings (“knobs”). If you don’t have the time or expertise to tune these knob settings, it negatively affects your PostgreSQL performance, scalability, and costs. OtterTune solves this problem by using machine learning to automatically–and continuously–optimize over 100 PostgreSQL configuration settings.Webcast Jan. 11: Human-in-the-Loop Control over Auto-tuning
When you provision an RDS PostgreSQL instance, Amazon launches it with their default configuration settings, which can be sub-optimal for most database workloads. In this benchmark, OtterTune doubled transaction throughput over the default RDS settings, and also out-performed recommendations from the pgTune configuration service.
In this talk from PGConf 2021, OtterTune CEO and Co-founder, Andy Pavlo explains how machine learning (ML) algorithms automatically generate and apply optimized PostgreSQL configurations for any application. OtterTune observes the database workload through its metrics and then trains models that recommend better knob values. He also highlights the lessons learned from real-world installations of OtterTune to tune PostgreSQL.
Securely connect OtterTune to your Amazon RDS or Aurora PostgreSQL database.
OtterTune retrieves information about your PostgreSQL database's hardware, knob configurations, and metrics. It does not access sensitive application data.
OtterTune machine learning algorithms optimize 100+ PostgreSQL configuration settings to improve your database performance. You can control how and when OtterTune applies configuration changes to PostgreSQL.
OtterTune removes the burden of having to understand the 100+ performance-related PostgreSQL configuration knobs…how they impact performance and cost, how they interact with each other, and how they should change as your database workload changes. OtterTune optimizes PostgreSQL knobs related to:
View the full list of 100+ PostgreSQL configuration settings OtterTune optimizes…