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

76 results found

  1. 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)
  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 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)
  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 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)
  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 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)
  8. 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)
  9. 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)
  10. 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)
  11. 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)
  12. 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)
  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 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)
  15. 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)
  16. 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)
  17. 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.

    Pgvectorscale is an open-source PostgreSQL extension that builds on pgvector, enabling greater performance and scalability.

    https://www.timescale.com/blog/pgvector-is-now-as-fast-as-pinecone-at-75-less-cost/
    https://github.com/timescale/pgvectorscale

    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 developer
    I want to fork databases as quickly as possible
    so that I can start developing new features immediately and run fast automated tests as a part of my CI/CD.
    In addition, this is especially important for larger database instances which can take a lot time to do a full copy of the entire dataset.

    Also known as copy on write or database branching.

    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. As a database administrator or developer, I would like to integrate PostgreSQL with Oracle databases using the oracle_fdw extension so that I can seamlessly access data in Oracle databases from within PostgreSQL using standard SQL queries. This feature simplifies data integration and allows for efficient cross-database operations without the need for complex data migration processes.

    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 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)
← Previous 1 3 4
  • Don't see your idea?