Skip to content
← Aiven Ideas

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

(thinking…)

I suggest you ...

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

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

23 results found

  1. Enable Configuration of log_parameter_max_length and log_parameter_max_length_on_error

    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
    Pending Review  ·  3 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  2. PostgreSQL metric for active sessions

    As a database engineer/devops engineer we want to be able to get a metric for actual active connections in the database (simliar to a query on pg-stat-activity with a state = 'active' clause) and have it available through an integration such as Datadog so that we can monitor DB load more accurately, and not just rely on underlying system metrics and other postgres metrics to make a best guess.

    6 votes
    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  3. aiven-extras support for "FOR ALL TABLES IN SCHEMA"

    Since version 15 PG CREATE PUBLICATION CREATE PUBLICATION statement added the clause FOR TABLES IN SCHEMA but this is not available in aiven-extras extension.

    5 votes
    Pending Review  ·  3 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  4. Allow creation of trigger events on Postgresql 17

    As a database administrator,I want to be able to create trigger events
    so that I can use them on the Postgresql 17 databases. I am unable to do so because the creation of trigger events is restricted to superusers.

    4 votes
    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  5. postgresql uri

    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
    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  6. PGbouncer as a service to point at multiple read-replicas

    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
    Pending Review  ·  1 comment  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  7. Instant database forking / branching

    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
    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  8. pg_mooncake

    I would like to be able to use data lakes from postgres and the pg_mooncake extension enables that.

    2 votes
    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  9. postgresql

    As Developper
    I want to configure Polish language
    so that I can use PostgreSQL's text search feature for autocomplete functionality
    In addition, find below some references to describe the configuration steps :

    https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/7/greenplum-database/admin_guide-textsearch-configuration.html

    https://github.com/judehunter/polish-tsearch

    2 votes
    Pending Review  ·  1 comment  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  10. Monospace Font in Aiven Console for the Optimize Query Screen

    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
    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  11. pgbouncer

    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.

    2 votes
    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  12. PGBouncer metrics displayed in Aiven Console Metrics page

    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.

    2 votes
    Pending Review  ·  1 comment  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  13. Issue RECONNECT command to pgbouncer

    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
    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  14. Support for being able to adjust the checkpoint_timeout parameter

    Requesting to allow the parameter to be adjustable so that WAL flush is more frequent and allow faster after-crash recovery option

    1 vote
    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  15. Release pg_repack v1.5.1 extension

    As a database administrator, developer or PO for Cloud Operations,
    I would like the pgrepack extension to be updated to version 1.5.1,
    to fix the issue we are encountering in version 1.5.0: https://github.com/reorg/pg    repack/issues/380 and to be compatible with my infrastructure

    1 vote
    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  16. Support for pgvector 0.8.0

    Our application is experiencing critical intermittent failures directly related to known issues in pgvector versions prior to 0.8.0. Needing pgvector versions greater than 0.8.0 to address the known issues.

    1 vote
    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  17. pg_curl

    I would like to set up cron jobs that make curl requests.

    1 vote
    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  18. pgrouting

    Since pgrouting 3.4 the function pgr_trspVia is available.

    Given a list of vertices and a graph, this function is equivalent to finding the shortest path between vertex(i) and vertex(i+1) for all i < sizeof(vertices) trying not to use restricted paths.

    The paths represents the sections of the route.

    The general algorithm is as follows:

    Execute a pgrdijkstraVia - Proposed.
    For the set of sub paths of the solution that pass through a restriction then
    Execute the TRSP algorithm with restrictions for the paths.
    NOTE when this is done, U    turnonedge flag is ignored.

    https://docs.pgrouting.org/

    1 vote
    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  19. Support VectorChord extension on Postgres

    As developer,
    I want to deploy a cost-efficient and fast vector database
    so that I can develop a fast-serving RAG application with large datasets.

    https://blog.vectorchord.ai/vectorchord-store-400k-vectors-for-1-in-postgresql

    1 vote
    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?

  20. Enhancing Database Search with PGroonga for Better Efficiency

    As a database administrator, I want to have the option to use the PGroonga extension so that I can take advantage of advanced text search capabilities, including full-text search with regular expressions and n-gram tokenization.
    In addition, PGroonga offers better performance for certain types of search operations, which is especially important for handling large datasets efficiently and improving the search functionality in applications.

    1 vote
    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    How important is this to you?
← Previous 1
  • Don't see your idea?