4 results found

1. Performance Insights for PostgreSQL/MySQL

   As a database administrator or developer, I would like to receive holistic analysis of my database performance, including optimization recommendations. This will ensure that my customers do not encounter performance issues, and I will be able to quickly identify and fix them without having to call a database specialist.

   Additionally, it is critical that the AI Performance insights be 100% non-intrusive and do not require access to my databases' sensitive data.

   53 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   2 comments  ·  Aiven for PostgreSQL®  ·  Delete…  ·  Admin →
   Available  ·  AdminOded Valin (Director of Product Management, Aiven.io) responded

   You can now optimize your PostgreSQL queries. Check out the 'AI Insights' tab on the PostgreSQL service page.

   https://aiven.io/solutions/aiven-ai-database-optimizer

   
   

   Stay tuned!  Additional holistic performance insights, and MySQL optimizations are coming soon.

2. Expose PgBouncer Statistics to Datadog

   As a database administrator or developer, I would like to expose PgBouncer statistics of Aiven for PostgreSQL services to Datadog so that I can efficiently monitor connection pool metrics and track application traffic for better database performance management.

   18 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Available  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Delete…  ·  Admin →

3. Support pgvector as a PostgreSQL Extension

   As a developer,
   I want to be able to perform efficient vector similarity and embeddings techniques directly in PostgreSQL,
   so that I can enable efficient handling of high-dimensional vector data within the PostgreSQL database for tasks like similarity search and machine learning.

   10 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Aiven for PostgreSQL®  ·  Delete…  ·  Admin →
   Available  ·  AdminJohn Joseph Kennedy (Head of Databases, Aiven.io) responded

   This feature has been released and is now present in all Aiven Postgresql plans. 

4. Standalone single SQL query optimization [PostgreSQL & MySQL]

   A fast way to optimize my PostgreSQL & MySQL queries automatically.

   As a software engineer, I would like to submit my query and receive a newly rewritten version of the query, optimized to run 10 times faster. These optimizations could potentially save my team an average of 50 weekly hours, which are currently spent manually optimizing these queries.
   I would like to perform these optimizations directly from Aiven's console, even if my Database is not hosted on Aiven yet.

   Additionally, It is critical that the optimization process be 100% non-intrusive and not require access to my databases' sensitive data.

   6 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Aiven for PostgreSQL®  ·  Delete…  ·  Admin →
   Available  ·  AdminOded Valin (Director of Product Management, Aiven.io) responded

   Now available! https://aiven.io/tools/sql-query-optimizer and inside the Aiven console (under tools).

   
   

   Please try it out and let us know if you got your query optimized.