105 results found
-
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 -
Admin can initiate failovers
As a DBA
I want to be able to click a button or call an API to initiate a primary -> secondary failover
so that I can recover from an issue that Aiven isn't detecting, or so I can exercise my own availability tests.
This should be available for all DB engines.Thank you
10 votes -
Ability to change join_buffer_size
As a MySQL user
I want to tune my service parameters according to best practises (in this case parameter joinbuffersize)
so that I can make my application performance better as I cannot use indexes
In addition, it might be useful to be able some other parameters mentioned here (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_join_buffer_size)2 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
6 votes -
Tiered Storage on Valkey
As an devops engineers
I want to store extensive amount of data on Valkey but only need part of them to be on memory
so that I can still utilize the low-latency nature of Valkey but also be able to retain as much data as I can without pay the cost for unnecessary memory.
In addition, i also want to be able to move data around different tiers12 votes -
ClickHouse Migration: Support for Restore using Backup from Object storage
As [your role]
I want to [describe what you need]
so that I can [describe the benefit or a problem you want to solve]
In addition, [share any additional context or why this idea is important to you]1 vote -
Expose pg_stat_statements.track_planning Configuration Parameter
As a database administrator, platform engineer or developer
I want to be able to enable the pgstatstatements.track_planning configuration parameter.2 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.
1 vote -
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 -
Support h3-pg as a PostgreSQL Extension
As a database administrator or developer, I would like to have H3 Hexagonal Hierarchical Geospatial Indexing System in PostgreSQL via h3-pg extension so that I can efficiently index and analyze geospatial data, including creating heatmaps and performing various spatial analyses, enhancing location-based decision-making for applications and services.
2 votes -
Serverless PostgreSQL and MySQL Databases
As a database administrator or developer, I would like to have serverless PostgreSQL and MySQL databases so that I can effortlessly scale my databases based on workload, ensure high availability, simplify deployment and integration, reduce operational overhead, and optimize costs.
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
- Don't see your idea?