Now available: AI-powered performance tuning for your Amazon RDS for PostgreSQL

DBtune now brings AI-powered performance tuning to Amazon RDS for PostgreSQL, available directly on the AWS Marketplace. This integration helps you safely and effortlessly unlock superior database performance. While Amazon RDS simplifies administration, DBtune takes it further by automating server parameter tuning to elevate your deployment's efficiency.

Are you looking for a real-world example? Here, CTO of Papershift, Florian, shares how they cut their average query time by 50% with DBtune. In Florian’s words, “we're happy to offload it to a robot”.

For a deep dive into the technical details and performance benchmarks, stay tuned for our companion technical post.

Why default AWS RDS settings limit your performance

While Amazon RDS for PostgreSQL provides smart default configurations that work well out-of-the-box, they are designed for broad compatibility, not for your specific application workload. This often leaves significant performance potential untapped. This is where DBtune shines, by analyzing your unique workload patterns and applying tailored configuration changes. In our tests, DBtune's AI-powered optimization achieved up to a 2.1x query performance improvement on AWS RDS without changing a single line of application code.

DBtune’s autonomous agent integrates seamlessly with Amazon RDS for PostgreSQL. The setup process is straightforward and typically takes about 30 minutes, allowing the system to safely drive your Amazon RDS for PostgreSQL instance toward peak efficiency in just a few hours. The agent uses an iterative process to actively monitor PostgreSQL database activity and hardware resource usage, communicating with the DBtune cloud service to receive tuning recommendations and apply optimized settings. DBtune’s process is iterative and safe.

Analysis: DBtune establishes a performance baseline using data from PostgreSQL's pg_stat_statements extension to understand your actual query patterns and workload.
Optimization: The AI engine learns the most effective parameter adjustments by systematically exploring new configurations on your live workload.
Evaluation: DBtune continuously evaluates performance against your chosen goal (e.g., lower query latency or higher throughput). If a change degrades performance or triggers a safety guardrail, it is immediately and automatically rolled back.

This iterative cycle safely drives your AWS RDS for PostgreSQL database towards peak efficiency in just a few hours.

Key benefits of DBtune’s support for AWS RDS for PostgreSQL

Automatic performance boost: Eliminate time-consuming manual tuning. DBtune automatically optimizes AWS RDS for PostgreSQL server parameters for your unique application workload, delivering up to 2.1x faster query runtimes. For a dive into the technical details and benchmark results, stay tuned for our companion technical post.
Cost optimization and right-sizing: Reduce infrastructure spending by avoiding unnecessary overprovisioning. DBtune maximizes the performance of your existing RDS instances, enabling you to right-size your resources.
Increased reliability: DBtune's safety guardrails and controlled parameter adjustments protect your database from risky configuration changes. The "reload-only" tuning option delivers significant improvements with zero downtime, ensuring stable and safe server configuration for production systems.

Get started: DBtune is now available on the AWS Marketplace

The future for AWS RDS for PostgreSQL performance tuning is human-guided and AI-accelerated.

Visit the AWS Marketplace to seamlessly integrate DBtune's AI-powered tuning with your AWS RDS for PostgreSQL deployment.
Try DBtune for free for up to 3 databases to see the performance boost firsthand.
For a deeper understanding of the product and setup guides for AWS RDS for PostgreSQL performance tuning, check out our documentation.

See how our customer Papershift cut their average query time by 50% using DBtune on Amazon RDS.

FAQs

Q: Where can I purchase or subscribe to DBtune for my Amazon RDS for PostgreSQL instance?

A: DBtune is available directly through the AWS Marketplace. Visit the Marketplace to subscribe and seamlessly integrate AI-powered AWS RDS PostgreSQL performance tuning with your RDS deployment.

Q: How do I get started with DBtune on Amazon RDS for PostgreSQL?

A: The setup process is straightforward and typically takes about 30 minutes. Please refer to our AWS RDS PostgreSQL documentation for complete setup guides.

Q: Is there a free trial for DBtune with RDS?

A: Yes, you can try DBtune for free for up to 3 databases and see how your specific workload on Amazon RDS for PostgreSQL can benefit. Try it now.

Q: Can I use DBtune on RDS without any downtime?

A: Absolutely. DBtune's reload-only tuning mode optimizes PostgreSQL parameters on Amazon RDS without requiring database restarts, delivering significant performance improvements with zero service interruption.

Q: How does DBtune compare to AWS Performance Insights?

A: AWS Performance Insights is an excellent monitoring tool, but it doesn’t automatically optimize parameters. DBtune uses data from Performance Insights, CloudWatch, and PostgreSQL statistics to automatically adjust a curated set of performance-critical parameters on Amazon RDS for PostgreSQL, based on your specific workload.

Q: Where can I find the full list of parameters tuned and technical details?

A: DBtune currently tunes 18 performance-critical parameters for RDS as explained in this blog post by Marc Linster. For the most updated list, please consult the DBtune AWS RDS for PostgreSQL documentation. You can also review our companion technical post for a deep dive into benchmark results.

Q: What happens if DBtune makes a change that hurts performance?

A: DBtune continuously monitors performance and automatically reverts any change that causes performance to degrade below the established baseline. Built-in safety guardrails prevent configurations that could destabilize the database.