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

30 results found

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

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

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

    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, using internaltmpmemstorageengine=TempTable (default), I would like the temptablemaxram size to be adjusted to the plan and not use the default value of 1G.

    When using the new default TempTable engine for temporary tables the setting temptablemaxram=1G (default) controls the max. amount of memory for ALL temporary tables.

    "The setting temptablemaxram controls how much is available to ALL temporary tables before converting to an on-disk table. Looking at our 50 queries example earlier, say each one needs 256MB of memory. With the default setting of 1GB, the…

    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)
  9. I would like to be able to use data lakes from postgres and the pg_mooncake extension enables that.

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

    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 an administrator
    I want to have high frequency backups of my Cassandra data
    so that I can restore with less data loss if there's a data corruption issue or outage

    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)
  12. 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)
  13. As a database admin or a developer,
    I would like to be able to terminate running queries in my database as admin,
    so that I would be able to unlock any long-running queries as part of my operations.

    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)
  14. 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)
  15. 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

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

    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. I would like to set up cron jobs that make curl requests.

    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. Setting these variables allows the ability to configure the cache parameter to avoid workload issues with prepared statement issues

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

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

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