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.
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 user data or queries.
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: