135 results found

1. Datadog Database Monitoring Explain Insights for PostgreSQL

   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.

   22 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Gathering Interest  ·  1 comment  ·  Aiven for PostgreSQL®  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. Almost zero downtime major release upgrades with logical replication

   Based on a similar mechanism with aivendbmigrate I would like to have major release upgrade mechanism based on logical replication.

   Steps:

   1. create an empty target instance with new major release
   2. create a full logical replication setup (like aivendbmigrate does) 2.1. inform users about limitations (lobs, schema changes during that period etc.) 2.2. inform users about testing and rollback capabilities
   3. perform the usual migrate thing with transferring everything and switch to a CDC state until next steps are defined
   4. provide specific cutover scenarios 4.1. DNS switch if possible? 4.2. some pgbouncer magic to prevent forced reconnections of clients (maybe some prerequisitis necessary)
   5. offering cutover in place or just to new instance

   Benefits are
   - in worst case downtime of the major release upgrade is just a "reconnect" away
   - testing capabilities during the CDC phase to verify that everything is fine after the major upgrade
   - if tests not successful a rollback is even not necessary
   - after cutover the old DB could be conserved for some time to get back to at least the last state before the cutover as kind of a disaster recovery case.

   The basics are IMHO already there in aivendbmigrate and even with the limitations of logical replication (which will be better with the next versions, and are better with pglogical) this would be a huge differentiator to other vendors, as this is best practices on premises but almost no cloud vendor offers similar solutions.

   Based on a similar mechanism with aivendbmigrate I would like to have major release upgrade mechanism based on logical replication.

   Steps:

   1. create an empty target instance with new major release
   2. create a full logical replication setup (like aivendbmigrate does) 2.1. inform users about limitations (lobs, schema changes during that period etc.) 2.2. inform users about testing and rollback capabilities
   3. perform the usual migrate thing with transferring everything and switch to a CDC state until next steps are defined
   4. provide specific cutover scenarios 4.1. DNS switch if possible? 4.2. some pgbouncer magic to prevent forced reconnections of… more
   12 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Gathering Interest  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

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

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

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

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

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

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

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

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

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

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

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

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. pg_mooncake

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

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

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

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

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

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

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

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

8. PG replication status through API

   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

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Gathering Interest  ·  1 comment  ·  Aiven for PostgreSQL®  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. pg_duckdb

   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.

   7 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Gathering Interest  ·  1 comment  ·  Aiven for PostgreSQL®  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

10. Support restoring PostgreSQL to a point before a major in-place upgrade

    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

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Gathering Interest  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. Support pg_jsonschema as a PostgreSQL Extension

    As a Software Engineer or DBA, I want to be able to enforce schemas on JSON/JSONB fields in a convenient manner, so that I can ensure bad data doesn't getting written to my database. https://github.com/supabase/pg_jsonschema seems to be the most popular extension for doing this.

    11 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Gathering Interest  ·  2 comments  ·  Aiven for PostgreSQL®  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

12. Multi-Region Standby Capability with Automatic Promotion for Relational Databases

    As a database administrator or developer, I would like multi-region standby capability for my PostgreSQL and MySQL databases so that I can ensure high-availability and business continuity by maintaining standbys across different regions, enabling automatic promotion in the event of a region-wide outage.

    47 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Roadmapped  ·  2 comments  ·  Aiven for PostgreSQL®  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

13. Adjust temptable_max_ram according to the plan

    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 first 4 queries would be stored in memory, and the remaining 46 queries would immediately go to disk as InnoDB temporary tables."

    Source: https://www.percona.com/blog/adjusting-mysql-8-0-memory-parameters/

    An application with heavy use on tmptables currently should use the internaltmpmemstorageengine=MEMORY setting, as this will allocate max tmptable_size=256M to each query connection.

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

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Pending Review  ·  0 comments  ·  Aiven for MySQL  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

14. pg_curl

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

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

15. Allow updating the table_definition_cache and table_open_cache MySQL parameters

    Setting these variables allows the ability to configure the cache parameter to avoid workload issues with prepared statement issues

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Pending Review  ·  0 comments  ·  Aiven for MySQL  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

16. 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, Uturnonedge flag is ignored.

    https://docs.pgrouting.org/

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

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

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

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

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

19. Support pg_embedding as a PostgreSQL extension

    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

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Pending Review  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

20. Logs in JSON format

    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

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Gathering Interest  ·  1 comment  ·  Aiven for PostgreSQL®  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close