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 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

Install the next configuration on the client DBMS

Collect runtime information from the client DBMS

Recommend the next configuration to improve performance

Visualize performance improvements and insights in the dashboard

1Connect arrow

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

2Collect arrow

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

3Optimize arrow

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…

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