72 results found
-
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 -
Standalone single SQL query optimization [PostgreSQL & MySQL]
A fast way to optimize my PostgreSQL & MySQL queries automatically.
As a software engineer, I would like to submit my query and receive 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, even if my Database is not hosted on Aiven yet.Additionally, It is critical that the optimization process be 100% non-intrusive and not require access to my databases' sensitive data.
6 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?