126 results found
-
Datadog Database Monitoring Explain Insights for PostgreSQL
As a database admin or a developer,
I would like the explain parameterized queries are enabled and the user agent's search path is configured to include all schemas in the Datadog agent configuration,
so that I would be able to fully utilize the Explain Insights module of the Datadog Database Monitoring feature with my PostgreSQL databases.21 votes -
Enable Configuration of log_parameter_max_length and log_parameter_max_length_on_error
As a Database Administrator,
I want to have the ability to configure the PostgreSQL parameters
log_parameter_max_lengthandlog_parameter_max_length_on_errorwithin Aiven's platform,so that I can prevent sensitive data from being exposed in database logs, especially during the logging of slow queries.
In addition, enabling this configuration is crucial for maintaining compliance with data protection regulations and upholding the privacy standards expected.
12 votes -
PG replication status through API
As a DBA
I want to monitor the PG replication status through API
so that I can know the replication status/log before promoting the replica
In addition, we a DRP process that will promote all our replicas to master through github action and we would like to know the status before promoting the replica7 votes -
PGbouncer as a service to point at multiple read-replicas
As a application user,
I want to instantiate a Single PG Bouncer service on Aiven to point across multiple READ-Replica Nodes so that I can it automatically handles the pooling of read connections.2 votes -
Support restoring PostgreSQL to a point before a major in-place upgrade
As Database Engineer
I want to be able to restore to a time before a major in-place upgrade
so that I can restore data in certain tables for our customers.
In addition, we communicate to customers that we can restore data back 30 days and an in-place upgrade does not allow that. Doing a fork and an upgrade causes additional downtime and complicates automation that makes use of naming standards.5 votes -
Multi-Region Standby Capability with Automatic Promotion for Relational Databases
As a database administrator or developer, I would like multi-region standby capability for my PostgreSQL and MySQL databases so that I can ensure high-availability and business continuity by maintaining standbys across different regions, enabling automatic promotion in the event of a region-wide outage.
47 votes -
Almost zero downtime major release upgrades with logical replication
Based on a similar mechanism with aivendbmigrate I would like to have major release upgrade mechanism based on logical replication.
Steps:
- create an empty target instance with new major release
- create a full logical replication setup (like aivendbmigrate does) 2.1. inform users about limitations (lobs, schema changes during that period etc.) 2.2. inform users about testing and rollback capabilities
- perform the usual migrate thing with transferring everything and switch to a CDC state until next steps are defined
- provide specific cutover scenarios 4.1. DNS switch if possible? 4.2. some pgbouncer magic to prevent forced reconnections of…
4 votes -
pg_duckdb
DuckDB has just launched a new pg_duckdb extension and I want to use it in my PostgreSQL database to improve the performance in analytics.
pg_duckdb is a Postgres extension that embeds DuckDB's columnar-vectorized analytics engine and features into Postgres.
5 votes -
Support pg_jsonschema as a PostgreSQL Extension
As a Software Engineer or DBA, I want to be able to enforce schemas on JSON/JSONB fields in a convenient manner, so that I can ensure bad data doesn't getting written to my database. https://github.com/supabase/pg_jsonschema seems to be the most popular extension for doing this.
8 votes -
Higher frequency backups for Cassandra
As an administrator
I want to have high frequency backups of my Cassandra data
so that I can restore with less data loss if there's a data corruption issue or outage2 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 -
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
15 votes -
Failover ready scaled read replica
As Database administrator, with a large footprint of applications being served,
I want to have a read only replica cluster in another region, that is sized appropriately, with it's own read replica nodes provisioned,
so that I can fail over and that read replica can quickly handle the production workload in the scenario of a disaster in one region/cloud vendor, to minimise any disruption to service.41 votes -
Allocate shards/nodes to Aiven for ValKey
As database administrator
I want to be able to allocate shards/nodes to Aiven for Valkey
so that I can:
- Distributes the dataset across multiple nodes, enabling horizontal scalibility.
- Implement a more cost-effective solution compared to scaling up a single server.
- Ensure redundancy and replication across multiple nodes, so that if one node fails, the system can continue to operate with minimal impact.1 vote -
Monospace Font in Aiven Console for the Optimize Query Screen
As a database administrator or developer,
I want to easily copy and compare SQL statements which would be easier to do with a monospace type font. It is visually difficult to compare SQL with variable width font.
Please convert the optimize query page to use a monospace font for the queries.
2 votes -
PGBouncer: Multiple processes
As a DBA I want to activate "so_reuseport" option so that PGBouncer can use multiple CPUs.
In the context of a very high concurrent database using PGBouncer, the single process can reach 100% CPU usage. Having multiple PGBouncer processes in the same instance would distribute the load between several processes.2 votes -
Support Citus as a PostgreSQL Extension
As a developer or database administrator,
I want to scale and distribute my PostgreSQL databases,
so that I can handle large-scale data processing and analytics workloads efficiently.The Citus extension offers the benefits of scalability, improved performance, fault tolerance, high availability, efficient data distribution, and seamless integration with PostgreSQL, enables the users to effectively manage and process large-scale data workloads.
58 votes -
Ability to Terminate a MySQL Query
As a database admin or a developer,
I would like to be able to terminate running queries in my database as admin,
so that I would be able to unlock any long-running queries as part of my operations.2 votes -
Issue RECONNECT command to pgbouncer
As a developer/DBA
I want to be able to issue the RECONNECT command to pgbouncer
so that I can ensure all connections reset and have access to up-to-date schema information during migrations.2 votes -
Support more robust major version Database upgrade mechanism
As a DevOps Engineer,
I want to be able to do in-place major version upgrade for Postgresql while maintaining ability to rollback to previous version in case there's apps error with the minimal data loss.
So that I can reduce effort for major version upgrade, which currently we need to fork and do logical replication (with other necessary stuff to do) for keeping the data in-sync with the master if we want the ability to rollback.
In addition, we have done the fork and logical replication with ability to rollback to old version while keeping the data in-sync between the…1 vote
- Don't see your idea?