94 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 -
Display a warning when updating parameters that require a restart
As a DBA or developer, I want to be warned if I am updating a parameter that will trigger a restart of my instance so that I can understand the consequences and avoid issues/mistakes.
Example of parameters: sharedbufferspercentage, autovacuumfreezemax_age
7 votes -
Initiate a high-availability takeover manually
As a database administrator,
I would like to be able to see the availability zone locations of the cloud region where my high-availability capable PostgreSQL or MySQL database cluster resides, and I would like to be able to initiate a manual high-availability takeover operation for that cluster,
so that I can have improved visibility of the availability zones where my database cluster instances are located, and I would have more authority on promotion of read-replicas for the the purpose of troubleshooting performance issues and avoiding incidental issues on specific availability zones.7 votes -
Support Hydra as a PostgreSQL Extension
As a database administrator or developer, I would like to query and analyze large volumes of data efficiently in PostgreSQL as a column-oriented database so that I can achieve fast and parallelized analytics without extensive code changes, reducing processing time from weeks to minutes.
7 votes -
Increased Storage for Databases
As a developer or database administrator,
I want to be able to create storage plans with a capacity up to 64 TB using persistent SSD storage,
so that I can scale up my storage as I grow my business towards enterprise.7 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 -
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 -
Backup scheduling for Redis
As a Redis developer/admin,
I want to schedule my back up to happen at a specific time
In order to plan ahead and create a fork that has a latest data6 votes -
Allow Mysql Slow Query log on read-only replicas
As a mysql administrator, I would like to be able to enable the slow query log on a read-only replica.
Current state.
The slow query log can have one of two output destinations. Log file, and the mysql.slowlog table on the server itself. Docs for reference
https://dev.mysql.com/doc/refman/8.0/en/log-destinations.html
Log Output:
This currently cannot be configured for Aiven managed Mysql services. This is because customers do not have access to the underlying filesystem for service nodes.
Table Output:
This is the output destination used by Aiven hosted Mysql services, for the same reasoning above.
This means that when an Aiven managed…6 votes -
Allow Safeguarded PostgreSQL Settings to be Lowered
As a database administrator or developer,
I would like to be able to lower the previously increased, safeguarded PostgreSQL settings,
so that I would be able to optimize the performance of my service according to its current state.6 votes -
Display the service startup/shutdown time in the GET service endpoint
As a devops
I want to have the service startup time in the GET service endpoint
so that I can know I a service has been UP or STOPPED since more than 7 days for example. For now I have to fetch the activity logs of the project, then look up for the service, then look for the right event (if the status of the service is UP then I'm looking for the "servicepoweron" event else the "servicepoweroff") but sometimes the service is UP for more than 1 year so I can't find the startup date of the…5 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.
5 votes -
Expose PgBouncer max_prepared_statements in the Advanced Configuration
As Database Administrator or Engineer,
I want to be able to edit the PgBouncer maxpreparedstatements configuration parameter, as it has a direct impact in the latency of the consumers of the database through the pool.Also, the default setting of 100 max prepared statements that Aiven has in the system is incorrect and will cause issues with ORM users when they upgrade the pgbouncer version in Aiven.
https://github.com/prisma/prisma/issues/21531#issuecomment-1794539086
5 votes -
See the end time or current status of a backup taking place
It would be great to be able to see the end time of when a backup is completed.
This way you can know how long the backup took. As well as monitor and see when the lock error will no longer occur.5 votes -
Support for scram
Aiven end customers and their security teams are asking for support for more modern authentication methods, mainly scram-sha256. Scram has been supported by Postgres since version 10. Introducing the support in Aiven platform would allow customers to enchance their database security.
5 votes -
Set up customized metrics for Datadog
As a developer against my Aiven for Cassandra instance,
I want to have advanced and customisable metrics that I can send to Datadog, in the same way I currently can for my Aiven for Kafka service,
so that I can get the metrics that are important for monitoring and analysing my workload.5 votes -
Configurable random_page_cost parameter in PostgreSQL Settings
As a customer,
I want to be able to configurerandom_page_cost
and optionallyseq_page_cost
in Postgres advanced configurations in order to influence the query planner.4 votes -
Support orafce as a PostgreSQL Extension
As a database administrator or developer, I would like to utilize the Orafce extension in PostgreSQL so that I can easily incorporate familiar database functions and packages from other systems, simplifying the migration process and ensuring compatibility with existing applications and data structures.
4 votes -
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 -
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.3 votes
- Don't see your idea?