Automated Aiven for PostgreSQL tuning now available with DBtune

We are excited to announce DBtune’s support for Aiven for PostgreSQL! This integration marks a significant advancement, empowering users to effortlessly achieve high and safe database performance on the Aiven cloud. Aiven for PostgreSQL provides a robust and multi-cloud managed database service, streamlining cloud database operations. For a deeper look into the performance improvements and details behind this integration, check out our companion technical post: From good to great, AI-powered Aiven for PostgreSQL server tuning.

Now, with DBtune's AI-powered, automated server parameter tuning capabilities for Aiven for PostgreSQL, users can elevate their Aiven PostgreSQL deployments by unlocking faster performance and efficiency. While Aiven provides excellent baseline configurations for their PostgreSQL instances, these are designed for general use. Your specific application workload — whether it's write-heavy, read-intensive, or mixed — has unique demands that generic settings can't optimally address. This is where DBtune for Aiven PostgreSQL shines. DBtune bridges this gap by continuously analyzing workload patterns and applying configuration changes tailored to your actual usage. The DBtune agent identifies optimal server parameter configurations to maximize performance, combining the strength of Aiven’s reliable infrastructure and DBtune’s hands-off, automated tuning.

DBtune's intelligent agent integrates seamlessly with Aiven for PostgreSQL. The agent actively monitors database activity, communicates with the DBtune cloud service to receive tuning recommendations, and applies these optimized settings to your Aiven database. For air-gapped, secure environments, DBtune can run in self-hosted mode, allowing you to orchestrate the tuning process entirely within your infrastructure with no external internet connection required. DBtune’s process is iterative and safe, comprising:

• Analysis: DBtune continuously analyzes key performance metrics, including query runtime, CPU usage, and memory consumption.
• Optimization: The AI engine learns the most effective parameter adjustments tailored to your specific workload on Aiven for PostgreSQL.
• Evaluation: DBtune monitors the impact of changes and refines settings to achieve optimal efficiency within the Aiven cloud.

This iterative cycle drives your database towards peak efficiency while incorporating safety mechanisms, to prevent instability or performance regressions. These include incremental parameter adjustments, continuous monitoring for negative impacts, and the ability to automatically roll back to previous stable configurations for critical issues. And it all happens within just a few hours!

Key benefits of DBtune’s support for Aiven for PostgreSQL

This release of DBtune support for Aiven for PostgreSQL has many benefits:

• Performance boost: Achieve substantially faster query runtimes and improved throughput. Our benchmark study demonstrates that this first release already achieves speedups of up to 2.15x on Aiven for PostgreSQL.
• Automated Aiven PostgreSQL tuning: Say goodbye to complex, time-consuming manual server parameter tuning in Aiven for PostgreSQL. DBtune handles it automatically.
• Workload tailoring: Attain the best possible performance customized to your application's unique requirements within the Aiven cloud.
• Increased reliability: DBtune's safety guardrails protect your database from risky configuration changes.

Performance benchmarks: Tuning results on Aiven for PostgreSQL

Our testing has consistently shown DBtune's ability to deliver impressive results with Aiven for PostgreSQL. DBtune achieved substantial speedups in average query runtime, for instance, in a mixed workload scenario (the BenchBase SEATS benchmark) on Aiven, DBtune achieved speedups of up to 2.15x. For a dive into the technical details and benchmark results, check out our companion technical article: From good to great: AI-powered Aiven for PostgreSQL server tuning.

Ready to see how DBtune can boost your Aiven for PostgreSQL performance? Try DBtune for free today — you can optimize up to three databases!

Key benefits of DBtune’s Aiven integration: FAQs

Q: How does DBtune compare to default Aiven PostgreSQL performance settings?

A: While Aiven offers a seamless managed experience with preconfigured server parameter defaults, these are intended as a starting point and may not fully address the specific demands of individual applications. DBtune bridges this gap by continuously analyzing workload patterns and applying configuration changes tailored to your actual usage. In benchmarks, DBtune has achieved up to a 2.15x improvement over default configurations provided by Aiven.

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

A: To get started, go to app.dbtune.com and sign in. Once authenticated, create a new database entry, giving it a name relevant to your environment. Ensure your database has an active workload, as DBtune requires live activity to analyze. Then, select Aiven for PostgreSQL as the managed service. Finally, set up the DBtune agent by ensuring pg_stat_statements is enabled on your Aiven instance and running a Docker command with your connection URL in a YAML config. Follow the DBtune Aiven user guide for more information.

Q: Is there a free trial for DBtune with Aiven PostgreSQL?

A: Yes, you can try DBtune for free today on up to three databases. No credit card is required to get started.

Q: Can DBtune automatically tune PostgreSQL server parameters on Aiven?

A: Yes, DBtune is an AI-powered platform that automatically tunes PostgreSQL server parameters to match your workload. It performs iterative configuration optimization, leveraging runtime telemetry to maximize throughput, minimize latency, and reduce resource waste.

Q: How can I improve performance in Aiven for PostgreSQL?

A: You can improve performance by integrating DBtune, which automates the tuning of PostgreSQL server parameters. DBtune continuously monitors performance and makes smart configuration changes based on your specific workload, leading to faster queries and better throughput.

Q: How much faster can Aiven PostgreSQL run with AI optimization?

A: The benchmark study “From good to great: AI-powered Aiven for PostgreSQL server tuning” demonstrates that DBtune can achieve speedups of up to 2.15x over default settings on Aiven for PostgreSQL.

Q: Is Aiven PostgreSQL optimized out of the box, or can performance be improved?

A: While Aiven offers a seamless managed experience with preconfigured server defaults, these are intended as a starting point. DBtune's automated tuning can significantly improve performance beyond these defaults by tailoring configurations to your specific application's workload.

Q: What parameters can be optimized on Aiven PostgreSQL?

A: DBtune optimizes PostgreSQL server parameters through its AI-powered platform. The AI engine learns the most effective parameter adjustments tailored to your specific workload. The updated list of parameters that can be tuned with DBtune can be found in the DBtune Aiven user guide.

Q: What kind of workloads benefit most from tuning Aiven PostgreSQL?

A: DBtune benefits any type of workload. It specifically excels in optimizing for your application's unique requirements by continuously analyzing workload patterns.

Q: Is manual tuning still needed on Aiven for PostgreSQL?

A: No, DBtune eliminates the complexity and time-consuming effort associated with manual server parameter tuning. It offers hands-off, automated tuning, with the best configuration automatically applied after a session.

Q: How safe is automatic tuning for production Aiven databases?

A: DBtune's process is iterative and safe, incorporating safety guardrail mechanisms to prevent instability or performance regressions. On Aiven, server 'reload' mode applies changes safely without downtime and is the recommended choice for production environments.