80 results found
-
pgbouncer
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.1 vote -
PGBouncer metrics displayed in Aiven Console Metrics page
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.1 vote -
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.
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 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.1 vote -
DB optimization, using query rewrites suggestions [PostgreSQL/MySQL]
A fast way to optimize my PostgreSQL & MySQL databases automatically.
As a software engineer/DevOps, I would like to see my slowest queries and receive recommendations along with a newly rewritten version of the query, optimized to run 10 times faster. These optimizations could potentially save my team an average of 50 weekly hours, which are currently spent manually optimizing these queries.
I would like to perform these optimizations directly from Aiven's console.Additionally, It is critical that the optimization process be 100% non-intrusive and not require access to my databases' sensitive data.
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 -
Active-Active Replication in PostgreSQL
As a database administrator or developer, I would like to enable 'active-active replication' in PostgreSQL so that I can ensure high availability for my database, minimize downtime during node failures, and efficiently distribute read and write workloads for effective load balancing.
1 vote -
Tiered Storage for PostgreSQL and MySQL Databases
As a database administrator or developer, I would like to have Tiered Storage for PostgreSQL and MySQL databases so that I can achieve cost-effectiveness for less frequently accessed data, ensure scalability, and efficiently manage data lifecycle.
1 vote -
Preserve Ownership for PostgreSQL Service Accounts in Terraform
As a user managing PostgreSQL service accounts through Terraform,
I want to ensure that enabling the replication option using your Terraform provider does not lead to the recreation of the service account.
This way, the service account can retain its ownership and privileges over database objects such as tables and functions, avoiding potential disruptions.
Additionally, maintaining ownership and privileges is crucial for seamless operation and consistency in our database management processes.1 vote -
Support tds_fdw as a PostgreSQL Extension
As a database administrator or developer, I would like to integrate PostgreSQL with external databases using the TDS protocol so that I can seamlessly access data in Microsoft SQL Server and Sybase databases from within PostgreSQL using standard SQL queries. This feature simplifies data integration and allows for efficient cross-database operations without the need for complex data migration processes.
1 vote -
Proactive Performance Alerts, AI-based [PostgreSQL/MySQL]
A fast way to Identify PostgreSQL & MySQL performance issues.
As a DevOps/DBA, I would like to get proactive alerts so that my customers will not encounter performance issues and I will be able to identify and fix them quickly without calling a database specialist.
Additionally, It is critical that the AI-based Performance Alerts be 100% non-intrusive and not require access to my databases' sensitive data
0 votes -
Support plrust as a PostgreSQL Extension
As a database administrator or developer, I would like to use PL/Rust as a trusted procedural language in PostgreSQL so that I can write natively-compiled functions in Rust for maximum performance, leverage Rust's extensive development ecosystem, and benefit from its compile-time safety guarantees, while seamlessly integrating with Postgres' Server Programming Interface and data types.
0 votes -
Support pg_tle as a PostgreSQL Extension
As a database administrator or developer, I would like to have Trusted Language Extensions for PostgreSQL (pg_tle) so that I can seamlessly extend and manage PostgreSQL functionality without needing filesystem access, addressing the challenge of adding extensions in restricted environments and enhancing security by allowing unprivileged users to install and use trusted extensions.
0 votes
- Don't see your idea?