Automatic PostgreSQL Optimization

Faster PostgreSQL performance & lower costs without the overhead of trial-and-error configuration tuning...
Tune Your First PostgreSQL Database For Free

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 your PostgreSQL configuration.

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.

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

3Optimize

OtterTune machine learning algorithms optimize 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 all of the 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 dozens of PostgreSQL knobs related to:
  • Caching
  • Buffering
  • Paging
  • Vacuuming
  • Logging
  • Threading
  • and others...

PostgreSQL Versions Supported

  • PostgreSQL versions 9.6, 10, 11, 12 and 13
  • Amazon RDS PostgreSQL
  • Amazon Aurora PostgreSQL

Ready to Put PostgreSQL Optimization on Autopilot?

Tune Your First PostgreSQL Database For Free