Skip to content

Operational Databases

Join our forum to discuss your ideas with Aiven community or check out our public roadmap.

Operational Databases

Categories

JUMP TO ANOTHER FORUM

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

119 results found

  1. As a developer, I want to be able to use Aiven's Dragonfly together with BullMQ which is a popular message queue library for NodeJS. They are not compatible today as BullMQ requires additional configuration flags to be set up for Dragonfly. BullMQ does work with Redis (and apparently Valkey) but Dragonfly compatibility isn't working out-of-the-box. Aiven could add these configuration flags to the Console UI to allow better compability with tools developed for the Redis ecosystem.

    This is also well documented on the Dragonfly website: https://www.dragonflydb.io/docs/integrations/bullmq

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. As a database administrator or developer,

    I want to easily copy and compare SQL statements which would be easier to do with a monospace type font. It is visually difficult to compare SQL with variable width font.

    Please convert the optimize query page to use a monospace font for the queries.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. As a developer,
    I want to be able to use the pgvector.rs extension (https://docs.pgvecto.rs/),
    so that I can have Scalable Vector Search in PostgreSQL.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. As a DBA I want to activate "so_reuseport" option so that PGBouncer can use multiple CPUs.
    In the context of a very high concurrent database using PGBouncer, the single process can reach 100% CPU usage. Having multiple PGBouncer processes in the same instance would distribute the load between several processes.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. As a DBA I want to activate "so_reuseport" option so that PGBouncer can use multiple CPUs.
    In the context of a very high concurrent database using PGBouncer, the single process can reach 100% CPU usage. Having multiple PGBouncer processes in the same instance would distribute the load between several processes.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. As a Systems Administrator
    I want to see PGBouncer Metrics (CPU/RAM/Network Usage) on the Aiven Console Metrics page
    so that I can quickly and easily see resource utilization across both PostgreSQL and PGBouncer.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. As a database admin or a developer,
    I would like to be able to terminate running queries in my database as admin,
    so that I would be able to unlock any long-running queries as part of my operations.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. As a DBA
    I want to monitor the PG replication status through API
    so that I can know the replication status/log before promoting the replica
    In addition, we a DRP process that will promote all our replicas to master through github action and we would like to know the status before promoting the replica

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. As a developer/DBA
    I want to be able to issue the RECONNECT command to pgbouncer
    so that I can ensure all connections reset and have access to up-to-date schema information during migrations.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. The ability to globally enforce the maxexecutiontime system variable would be great to have

    https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_max_execution_time

    As it would help with limiting the long running queries happening that are left unchecked.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. As a database admin or a developer,
    I would like the explain parameterized queries are enabled and the user agent's search path is configured to include all schemas in the Datadog agent configuration,
    so that I would be able to fully utilize the Explain Insights module of the Datadog Database Monitoring feature with my PostgreSQL databases.

    19 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. DuckDB has just launched a new pg_duckdb extension and I want to use it in my PostgreSQL database to improve the performance in analytics.

    pg_duckdb is a Postgres extension that embeds DuckDB's columnar-vectorized analytics engine and features into Postgres.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. As developer,
    I want to use the ip4r extension as the built-in IP address types in Postgres work okay for many applications, but are lacking when it comes to applications that heavily work with IPs, like ours. ip4r adds several IP types with expanded functionalities that enable us to perform far more efficient "IP in range" type lookups, as well as tracking IP ranges that don't fall neatly in CIDR boundaries, plus general performance improvements. Very useful for our malicious IP threat feed service, abuseipdb.com, as you can imagine.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. As db admin
    I want to add bktree extension for Postgres
    so that I can do a similarity search based on hamming distance
    In addition, this extension also includes the SP-GiST.

    Please see the following repository:
    https://github.com/fake-name/pg-spgist_hamming

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. As a Database Administrator,

    I want to have the ability to configure the PostgreSQL parameters log_parameter_max_length and log_parameter_max_length_on_error within Aiven's platform,

    so that I can prevent sensitive data from being exposed in database logs, especially during the logging of slow queries.

    In addition, enabling this configuration is crucial for maintaining compliance with data protection regulations and upholding the privacy standards expected.

    12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. As developer
    I want to create event triggers
    so that I can react to DDL changes across the entire database.

    Aiven for Postgres currently does not support Event Triggers: https://www.postgresql.org/docs/16/event-triggers.html

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. With Redis, it is generally possible to add a new password for a user without immediately invaliding the old one.

    This makes it much easier to manage password rotation without incurring downtime.

    Aiven for Caching blocks access to the ACL commands, and the UI, API, CLI only allow for resetting the current password.

    The admin interfaces for Caching should allow to Add Password and Remove Password

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. As a developer, I would like to simplify the process of building search and Retrieval Augmented Generation (RAG) AI applications with PostgreSQL so that embedding and generation AI models are closer to the database, enabling me to create embeddings, retrieve LLM chat completions, generate responses, and reason over data directly within SQL queries.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. As a developer or database admin, I would like a query editor built into the Aiven Console to improve my productivity, allow a streamlined workflow, facilitate trainings, and ease of use for unfamiliar users so that I can run queries directly on the Aiven Console on the web without needing to use additional tools.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. As a database administrator or developer, I would like to have audit logging capability in the system so that I can track and monitor user activities, maintain data security, and ensure compliance with regulatory requirements.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
← Previous 1 3 4 5 6
  • Don't see your idea?