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

84 results found

  1. As a database administrator or developer,
    I would like to utilize the pg_profile extension in PostgreSQL,
    so that I would be able to identify the most resource intensive activities in my databases.

    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)
  2. 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)
  3. 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

    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 DBA or SRE, I want to be able to monitor more pgbouncer metrics. Please add support of pgbouncer input plugin for telegraf to expose prometheus endpoint
    https://github.com/influxdata/telegraf/tree/master/plugins/inputs/pgbouncer

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

    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)
  6. 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)
  7. As a database administrator, developer or PO for Cloud Operations,
    I would like the pg_partman extension to be updated to version 5.0.0,
    so that I can keep my infrastructure compatible.

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

    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)
  11. As a DBA
    I want to access the pg_monitor role
    so that I can integrate with my in-house monitoring solution
    In addition, this could be via aiven-extras or an advanced configuration if necessary

    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)
  12. 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)
  13. 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

    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)
  14. As Database Engineer
    I want to be able to restore to a time before a major in-place upgrade
    so that I can restore data in certain tables for our customers.
    In addition, we communicate to customers that we can restore data back 30 days and an in-place upgrade does not allow that. Doing a fork and an upgrade causes additional downtime and complicates automation that makes use of naming standards.

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

    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. 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)
  18. 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)
  19. As a developer
    I want to copy-paste the Service URI from the Aiven console
    so that I can use it in Java JDBC connection strings as is without changing postgres:// to postgresql:// (see https://jdbc.postgresql.org/documentation/use/).
    In addition, the official docs allow both postgresql:// and postgres://, but JDBC does not seem to honour this: https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING-URIS

    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)
  20. As a application user,
    I want to instantiate a Single PG Bouncer service on Aiven to point across multiple READ-Replica Nodes so that I can it automatically handles the pooling of read connections.

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