67 results found
-
PGBouncer: Multiple processes
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 -
Support postgres extension ip4r
As developer,
I want to use the ip4r extension as the built-in IP address types in Postgres work okay for many applications, but are lacking when it comes to applications that heavily work with IPs, like ours. ip4r adds several IP types with expanded functionalities that enable us to perform far more efficient "IP in range" type lookups, as well as tracking IP ranges that don't fall neatly in CIDR boundaries, plus general performance improvements. Very useful for our malicious IP threat feed service, abuseipdb.com, as you can imagine.2 votes -
Support pgvectorscale as a PostgreSQL Extension
As a developer,
I want to be able to perform efficient vector similarity and embeddings techniques directly in PostgreSQL, so that I can enable efficient handling of high-dimensional vector data within the PostgreSQL database for tasks like similarity search and machine learning.Pgvectorscale is an open-source PostgreSQL extension that builds on pgvector, enabling greater performance and scalability.
https://www.timescale.com/blog/pgvector-is-now-as-fast-as-pinecone-at-75-less-cost/
https://github.com/timescale/pgvectorscale2 votes -
Support PLV8 on versions of Postgres greater than 10
As Software Developer
I want to use PLV8 on Postgres 16
so that I can use Javascript as a procedural language on my PG 16 service.2 votes -
Expose the metric filecount_size_bytes
As backend and DevOps engineer / SRM, I want to be able to visualize in Grafana metrics related to WAL files buildup due to lagging or missing replication slots.
This will help us debug WAL bloat which might exhaust the disk space and better understand the cause.Mainly the metric
filecount_size_byteswill be useful. Also any metric that would allow us to monitor per database service:
1. Total WAL size.
2. Size of WAL retained due to replication lag.
3. Rate in which we consume the WAL for the replication over time (connector consumption rate).
4. Rate in which we…2 votes -
Recreation of replication slot after power cycle
As a DBA or developer,
I want to be able to stop/start my services without losing replication slots
so that I can resume my logical replication flows even after a power cycle.Similar recreation is currently done during nodes failover: https://aiven.io/blog/aiven-for-pg-recreates-logical-replication-slots
2 votes -
Change the default SSL Mode
Make it possible to change the default SSL mode.
This way, by setting this value to "verify-full", we can make it so that anyone trying to connect to the database MUST have the CA certificate.Because currently, what's the point of the CA certificate if it is not mandatory?
2 votes -
PostgreSQL logging JSON format with OpenSearch integration
As DBA I want to have better logging using the PostgreSQL v15 logging feature to save the logs in JSON format so that I can integrate these logs in OpenSearch and provide better readability of these logs.
This will provide 2 things:
1 - Parse of the fields of the log entries -> give more capabilities searching the logs - easily filter some field like user/database/application name
2 - Multi line queries in one log entry -> right now, multi line queries saves each line in a different log entry, which is very hard to filter a full query since…2 votes -
Expose pg_stat_statements.track_planning Configuration Parameter
As a database administrator, platform engineer or developer
I want to be able to enable the pgstatstatements.track_planning configuration parameter.2 votes -
Support h3-pg as a PostgreSQL Extension
As a database administrator or developer, I would like to have H3 Hexagonal Hierarchical Geospatial Indexing System in PostgreSQL via h3-pg extension so that I can efficiently index and analyze geospatial data, including creating heatmaps and performing various spatial analyses, enhancing location-based decision-making for applications and services.
2 votes -
Replicate the usage of Oracle Autonomous Transaction
As developer or DBA
I want to be able to reproduce the behavior of Oracle Autonomous Transaction inside Postgres.
so that I can create a different transaction that is not impacting the current one. Use case can be logging for example),
In addition, this can be achieved using DBLinks but it requires to put the password inside a plSQL function. To avoid that, Aiven could have a new parameter allowing local connections without password.2 votes -
Support pgvecto.rs as a PostgreSQL Extension
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.1 vote -
Bktree_spgist
As db admin
I want to add bktree extension for Postgres
so that I can do a similarity search based on hamming distance
In addition, this extension also includes the SP-GiST.Please see the following repository:
https://github.com/fake-name/pg-spgist_hamming1 vote -
Support Postgres Event Triggers
As developer
I want to create event triggers
so that I can react to DDL changes across the entire database.Aiven for Postgres currently does not support Event Triggers: https://www.postgresql.org/docs/16/event-triggers.html
1 vote -
Built-in Query Editor in Aiven Console for PostgreSQL
As a developer or database admin, I would like a query editor built into the Aiven Console to improve my productivity, allow a streamlined workflow, facilitate trainings, and ease of use for unfamiliar users so that I can run queries directly on the Aiven Console on the web without needing to use additional tools.
1 vote -
Display a warning when updating parameters that cannot be lowered once increased
There are parameters like the 'maxworkerprocesses' that cannot be lowered once it's been enabled and increased with the warning message: "PostgreSQL setting 'maxworkerprocesses' cannot be lowered from its current value". It would be nice to be warned prior to toggling and increasing these settings.
1 vote -
pgoutput
As a dba
I want to add the PGOUTPUT extension
so that we can use this type of logical replication
In addition, it is important as our system integration requires it to work, and it is generally better performing over test_decoding1 vote -
Set PostgreSQL Client Connection Port Within the Public Ports Range
As a database administrator or developer,
I would like to be able to set the database client connection port within the allowed public ports range,
So that I would be able to set the same port for all of my services which will allow me to have unified persistent rule on my firewall for my databases, facilitating smooth database operation within the firewall parameters. Altering firewall configurations can prove arduous.1 vote -
Support pg_stat_kcache as a PostgreSQL Extension
As a database administrator or developer,
I would like to utilize the pgstatkcache extension in PostgreSQL,
so that I would be able to gather statistics on system metrics such as CPU usage and physical disk access, and see how much resource each query, user and/or database is consuming.1 vote -
Support PGroonga extension for PostgreSQL
As a developer, I would like to enable the PGroonga extension for PostgreSQL so that I can harness the full-text search capability of PostgreSQL across all languages, including Japanese and Chinese, enhancing the versatility and inclusivity of my search functionality.
1 vote
- Don't see your idea?