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

104 results found

  1. As an devops engineers
    I want to store extensive amount of data on Valkey but only need part of them to be on memory
    so that I can still utilize the low-latency nature of Valkey but also be able to retain as much data as I can without pay the cost for unnecessary memory.
    In addition, i also want to be able to move data around different tiers

    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)
  2. 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)
  3. As a database administrator or developer,
    I would like to utilize the pgwaitsampling extension in PostgreSQL,
    so that I would be able to gather sampling-based statistics on wait events for troubleshooting dependencies for queries that take longer than expected.

    8 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)
  4. As a devops engineer/admin,
    I want to run both read/write request to the Valkey clusters that locates closest geographically region
    So that I can reduce the latency and improve the experience of my end-user

    20 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)
  5. 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.

    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)
  6. As a database administrator, I want the option to be able to set the lowercasetablenames MySQL parameter in the event of migration requiring the lowercasetablenames is different than 0

    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)
  7. As a devops
    I want to have the service startup time in the GET service endpoint
    so that I can know I a service has been UP or STOPPED since more than 7 days for example. For now I have to fetch the activity logs of the project, then look up for the service, then look for the right event (if the status of the service is UP then I'm looking for the "servicepoweron" event else the "servicepoweroff") but sometimes the service is UP for more than 1 year so I can't find the startup date of the…

    5 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 site reliability engineer,
    I want to be able to create a highly available read-replica service,
    so that I can use it in the critical path of my application without availability being affected by loss of a single node.
    In addition, this can currently be achieved via at least two separate read-replica services (currently plans are limited to those with only one node) and appropriate client configuration, but Aiven should be able to do this for me instead.

    13 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 DBA
    I want to be able to click a button or call an API to initiate a primary -> secondary failover
    so that I can recover from an issue that Aiven isn't detecting, or so I can exercise my own availability tests.
    This should be available for all DB engines.

    Thank you

    10 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. As a database administrator or developer, I would like to see PgBouncer logging.
    At minimal I should be able to see connection pool creation/deletion/changes and all outbound clients connected to which pool with source IPs.
    1. pgbouncer logs should be available by "avn service logs" and aiven console.
    2. pgbouncer logs should be available with rsyslog integration to 3rd parties.
    3. ideally logging level can be controlled by pg service config parameter pg.logerrorverbosity
    bonus: pgbouncer stats ingested into logging.

    14 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)
  11. As a customer,
    I want to be able to configure random_page_cost and optionally seq_page_cost in Postgres advanced configurations in order to influence the query planner.

    4 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. 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)
  13. 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)
  14. As a database administrator or developer,
    I would like to be able to access and read binary logs of the database service by using third-party utilities,
    so that I would be able to perform the tasks security auditing, replication monitoring and possibly data recovery on the database.

    5 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)
  15. As a database administrator or developer,
    I would like to integrate LDAP authentication with PostgreSQL,
    So that user management becomes centralized through existing LDAP services like ActiveDirectory, enhancing security, simplifying authentication, and eliminating the need for separate authentication methods.

    16 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 a database administrator or developer, I would like to perform in-place major upgrades on standby nodes and read-replicas for PostgreSQL so that the whole upgrade window is considerably shorter, resulting in increased high-availability for standbys and improved availability for read replicas. This feature will also alleviate any bottlenecks caused by the quorum sync replication, enhancing the overall database system's efficiency and resilience.

    11 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)
  17. There are parameters like the 'maxworkerprocesses' that cannot be lowered once it's been enabled and increased with the warning message: "PostgreSQL setting 'maxworkerprocesses' cannot be lowered from its current value". It would be nice to be warned prior to toggling and increasing these settings.

    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)
  18. As a database administrator or developer,
    I would like to integrate Kerberos authentication with PostgreSQL,
    So that user management becomes centralized through existing Kerberos services like ActiveDirectory, enhancing security, simplifying authentication, and eliminating the need for separate authentication methods.

    3 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)
  19. Allowing WAL compression could be beneficial for several reasons: reduction of disk space usage, IO efficiency, faster replication, generally improving performance.

    6 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)
  20. As database administrator or developer,
    I want to see both the primary and read-only connections in the connections tab of the web console
    so that I can observe all of the connections at the same time

    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)
  • Don't see your idea?