140 results found

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

   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

   Submit Rating

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

   Submit Rating

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

   Submit Rating

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

   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

   Submit Rating

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

   Submit Rating

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

   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

   Submit Rating

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

   Submit Rating

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

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

   Submit Rating

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

   Submit Rating

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

    Submit Rating

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

    Submit Rating

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

    Submit Rating

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

    Submit Rating

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

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

    Submit Rating

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/pgrepack/issues/380 and to be compatible with my infrastructure

    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

    Submit Rating

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

    Submit Rating

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

    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

    Submit Rating

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

    Submit Rating

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

    Submit Rating

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

    Submit Rating