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

64 results found

  1. As a dba
    I want to add the PGOUTPUT extension
    so that we can use this type of logical replication
    In addition, it is important as our system integration requires it to work, and it is generally better performing over test_decoding

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

    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)
  3. As a database administrator,
    I would like to be able to see the availability zone locations of the cloud region where my high-availability capable PostgreSQL or MySQL database cluster resides, and I would like to be able to initiate a manual high-availability takeover operation for that cluster,
    so that I can have improved visibility of the availability zones where my database cluster instances are located, and I would have more authority on promotion of read-replicas for the the purpose of troubleshooting performance issues and avoiding incidental issues on specific availability zones.

    9 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 DBA or developer, I want to be warned if I am updating a parameter that will trigger a restart of my instance so that I can understand the consequences and avoid issues/mistakes.

    Example of parameters: sharedbufferspercentage, autovacuumfreezemax_age

    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)
  5. As Database Administrator or Engineer,
    I want to be able to edit the PgBouncer maxpreparedstatements configuration parameter, as it has a direct impact in the latency of the consumers of the database through the pool.

    Also, the default setting of 100 max prepared statements that Aiven has in the system is incorrect and will cause issues with ORM users when they upgrade the pgbouncer version in Aiven.

    https://github.com/prisma/prisma/issues/21531#issuecomment-1794539086

    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)
  6. As a database administrator for a large enterprise,
    I want to be able to leverage an Aiven platform API,
    so that I can extract and archive, logical backups of my instances in order to meet and pass industry audit and compliance checks for data retention.
    These periods of retention could vary but be as long as 3 years. I would not expect to be able to restore these logical backups in the Aiven platform, and would be manage this myself should I need to.

    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)
  7. As a database administrator or developer,
    I would like to perform a cascade power off operation on a database service with read replicas when a power off operation is initiated,
    so that the service hierarchy is navigated, starting with powering off the replicas and ending with the master, all in a single uninterrupted transaction.
    This feature aims to prevent customers from having to set up automatic schedulers on their environments, reducing resource waste and ensuring a seamless and efficient power off process for the database service.

    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)
  8. As a database administrator or developer,
    I would like to access the service upgrade logs after a failed and reverted upgrade,
    so that I would be able to troubleshoot the problem myself before retrying, and without requiring the assistance of the support team.

    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)
  9. 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.

    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)
  10. As an Operations Engineer
    I want to have logs in JSON format
    so that I can process them in third-party log management and analytics systems without having to write custom parsing rules.

    Related PostgreSQL documentation: https://www.postgresql.org/docs/15/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-JSONLOG

    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)
  11. As a database administrator or developer, I would like to query and analyze large volumes of data efficiently in PostgreSQL as a column-oriented database so that I can achieve fast and parallelized analytics without extensive code changes, reducing processing time from weeks to minutes.

    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)
  12. As a database administrator or developer,
    I would like to be able to set the database client connection port within the allowed public ports range,
    So that I would be able to set the same port for all of my services which will allow me to have unified persistent rule on my firewall for my databases, facilitating smooth database operation within the firewall parameters. Altering firewall configurations can prove arduous.

    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 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.

    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. Make it possible to change the default SSL mode.
    This way, by setting this value to "verify-full", we can make it so that anyone trying to connect to the database MUST have the CA certificate.

    Because currently, what's the point of the CA certificate if it is not mandatory?

    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 or developer, I would like to utilize the Orafce extension in PostgreSQL so that I can easily incorporate familiar database functions and packages from other systems, simplifying the migration process and ensuring compatibility with existing applications and data structures.

    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)
  16. Aiven end customers and their security teams are asking for support for more modern authentication methods, mainly scram-sha256. Scram has been supported by Postgres since version 10. Introducing the support in Aiven platform would allow customers to enchance their database security.

    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)
  17. As a database administrator, platform engineer or developer
    I want to be able to enable the pgstatstatements.track_planning configuration parameter.

    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 database administrator or developer,
    I would like to be able to lower the previously increased, safeguarded PostgreSQL settings,
    so that I would be able to optimize the performance of my service according to its current state.

    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)
  19. 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.

    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 developer or database administrator,
    I want to be able to create storage plans with a capacity up to 64 TB using persistent SSD storage,
    so that I can scale up my storage as I grow my business towards enterprise.

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