140 results found
-
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.
1 vote -
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 -
Large Language Models (LLMs) hosted to build AI capabilities
As a developer with data stored in one of the operational databases,
I want to host and train Large Language Models, (LLMs) (open source) on Aiven
so that I can leverage the power of LLMs to improve the experience of my application.
In addition, I'd like to host a knowledge graph to act as a filter to reduce hallucinations and have built in RAG capabilities hosted on Aiven.1 vote -
innodb_buffer_pool_size
As a customer
I want to change the values ofinnodb_buffer_pool_size,innodb_buffer_pool_instances, andinnodb_buffer_pool_chunk_size
so that I can tune the DB config to better suit my workload
In addition, I understand that any changes should be within sensible limits, as taking too much memory away from the OS can cause OOM errors.3 votes -
Support pg_profile as a PostgreSQL Extension
As a database administrator or developer,
I would like to utilize the pg_profile extension in PostgreSQL,
so that I would be able to identify the most resource intensive activities in my databases.8 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 -
Access to MySQL Binary Logs
As a database administrator or developer,
I would like to be able to access and read binary logs of the database service by using third-party utilities,
so that I would be able to perform the tasks security auditing, replication monitoring and possibly data recovery on the database.5 votes -
Ability to Change the MySQL Optimizer Behavior
As a database administrator or developer,
I would like to be able to change the behavior of the MySQL Optimizer at the global level by changing the variable of the optimizerswitch with values such as "indexmergeintersection=off" or "preferordering_index=off",
so that I would be able to optimize my query performance.2 votes -
Logs in JSON format
As an Operations Engineer
I want to have logs in JSON format
so that I can process them in third-party log management and analytics systems without having to write custom parsing rules.Related PostgreSQL documentation: https://www.postgresql.org/docs/15/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-JSONLOG
17 votes -
Support pg_wait_sampling as a PostgreSQL Extension
As a database administrator or developer,
I would like to utilize the pgwaitsampling extension in PostgreSQL,
so that I would be able to gather sampling-based statistics on wait events for troubleshooting dependencies for queries that take longer than expected.8 votes -
Make PostgreSQL Upgrade Logs Available Post Upgrade Failure
As a database administrator or developer,
I would like to access the service upgrade logs after a failed and reverted upgrade,
so that I would be able to troubleshoot the problem myself before retrying, and without requiring the assistance of the support team.3 votes -
Support Certificate Authentication on Postgres
As a developer,
I want to connect to my Aiven for Postgres services without providing credentials and use only certificate authentication as offered by Postgres https://www.postgresql.org/docs/current/auth-cert.html
so that I can be compliant with my internal security policies18 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 -
Support for wal_compression in PostgreSQL services
Allowing WAL compression could be beneficial for several reasons: reduction of disk space usage, IO efficiency, faster replication, generally improving performance.
6 votes -
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 -
Access to Valkey administration commands
As a Database Reliability Engineer, I would like to be able to use commands such as ACL or Monitor when investigating some operational and performance issues and be able to check the documentation to find out which commands are available.
1 voteThese commands are blocked so that Aiven can control the service and keep it secure and available. We provide a subset of these commands to control ACLs. We also do not expose the monitor command since it will block the server completely due to the performance overhead. This is something we are improving in our documentation (which commands are specifically blocked). Look for a new documentation page to be published this month with additional details.
- Don't see your idea?