Automatic PostgreSQL Optimization

Faster PostgreSQL performance & lower costs without the overhead of trial-and-error configuration tuning...

Let Machine Learning automate your PostgreSQL configuration tuning

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

Benchmark: 2x better PostgreSQL performance

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.

Read the benchmark

Deep dive: Using Machine Learning to Auto-Tune PostgreSQL

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.

How automatic PostgreSQL tuning works

1Connect

Securely connect OtterTune to your Amazon RDS or Aurora PostgreSQL database.

2Collect

OtterTune retrieves information about your PostgreSQL database's hardware, knob configurations, and metrics. It does not access sensitive application data.

3Optimize

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.

What PostgreSQL knobs does OtterTune optimize?

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:

Caching
Buffering
Paging
Vacuuming
Logging
Threading
and others…

View the full list of 100+ PostgreSQL configuration settings OtterTune optimizes…