76 results found
-
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 -
Support Bingo as a PostgreSQL Extension
As a developer or chemical database administrator,
I would like to perform chemical substructure searches and similarity searches on molecules and reactions efficiently,
so that I can quickly retrieve relevant chemical data and improve the accuracy and speed of chemical searches within the PostgreSQL database.3 votes -
Utilizing Row Level Security (RLS) and the BYPASSRLS Attribute
As a security administrator or developer, I would like to utilize Row-Level Security (RLS) in PostgreSQL so that I can control data access at a granular level based on specific conditions, ensuring that users only see and modify the data they are authorized to access. Additionally, I want the ability to assign the BYPASSRLS attribute to trusted roles or users when necessary, allowing them to have unrestricted access to data while still maintaining overall security.
3 votes -
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 -
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 -
Release pg_partman Version 5.0.0 as a PostgreSQL Extension
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.7 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.1 vote -
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 -
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 -
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.
0 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 -
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 -
Access to the pg_monitor role
As a DBA
I want to access the pg_monitor role
so that I can integrate with my in-house monitoring solution
In addition, this could be via aiven-extras or an advanced configuration if necessary6 votes -
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.
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?