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

139 results found

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

    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 software engineer
    I want to use pg_embedding
    so that I can perform faster (20x) vector searches in PostgreSQL.
    In addition, ML use cases are everywhere now and reducing search times will impact many projects.

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

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

    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 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)
  10. As a developer or database administrator our customer is planning to use Apache Age (https://github.com/apache/age) in their Managed Service for Timescale (MST) deployments which is provided by Aiven.
    I cannot see this extension in the list but is there any way or plan to add this into the managed services.

    Thanks!

    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)
  11. As a developer,
    I want to connect to my Aiven for Postgres services without providing credentials and use only certificate authentication as offered by Postgres https://www.postgresql.org/docs/current/auth-cert.html
    so that I can be compliant with my internal security policies

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

    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, with a large footprint of applications being served,
    I want to have a read only replica cluster in another region, that is sized appropriately, with it's own read replica nodes provisioned,
    so that I can fail over and that read replica can quickly handle the production workload in the scenario of a disaster in one region/cloud vendor, to minimise any disruption to service.

    41 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 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)
  15. As a data privacy officer, database administrator, data analyst/researcher, or compliance officer, I would like the ability to anonymize sensitive data in the database by masking or replacing personally identifiable information (PII) or commercially sensitive data so that I can protect individuals' privacy and ensure compliance with data protection regulations such as HIPAA and GDPR.

    31 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 developer or database administrator,
    I want to scale and distribute my PostgreSQL databases,
    so that I can handle large-scale data processing and analytics workloads efficiently.

    The Citus extension offers the benefits of scalability, improved performance, fault tolerance, high availability, efficient data distribution, and seamless integration with PostgreSQL, enables the users to effectively manage and process large-scale data workloads.

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

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

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

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