124 results found
-
Replicate the usage of Oracle Autonomous Transaction
As developer or DBA
I want to be able to reproduce the behavior of Oracle Autonomous Transaction inside Postgres.
so that I can create a different transaction that is not impacting the current one. Use case can be logging for example),
In addition, this can be achieved using DBLinks but it requires to put the password inside a plSQL function. To avoid that, Aiven could have a new parameter allowing local connections without password.2 votes -
Support ScyllaDB as an alternative to Aiven for Cassandra
As a Cassandra user,
I would like to reduce operational overhead (ex. Java) and reduce cost of my Cassandra (self-managed or on Aiven) service without code changes and while benefiting from all the advantages of Cassandra.2 votes -
CEP-28: Reading and Writing Cassandra Data with Spark Bulk Analytics
As developer using Cassandra for analytics workloads,
I want to be able to create a custom Spark application,
so that I can read and write large amounts of data from Cassandra.
The Cassandra current APIs aren't designed for large scale data egress/ingest.2 votes -
Advanced Keyspace management
As someone running production workloads against Aiven for Cassandra,
I want to have more control over management of the keyspaces in my database,
so that I can adapt more quickly to changing workloads and meet internal criteria relating to levels of control for adopting an external service.2 votes -
Control of nodetool cleanup and compact
As a database administrator of an Aiven for Cassandra instance,
I want to be able to have some control over when and where compactions and cleanups occur on my instances,
so that I can keep my discs optimised and at a time that fits my workload.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 -
Support pg_squeeze as a PostgreSQL Extension
pgsqueeze is tries to replace pgrepack extension and it would be great if Aiven did support it.
https://github.com/cybertec-postgresql/pg_squeeze1 vote -
Dragonfly <> BullMQ compatibility flags
As a developer, I want to be able to use Aiven's Dragonfly together with BullMQ which is a popular message queue library for NodeJS. They are not compatible today as BullMQ requires additional configuration flags to be set up for Dragonfly. BullMQ does work with Redis (and apparently Valkey) but Dragonfly compatibility isn't working out-of-the-box. Aiven could add these configuration flags to the Console UI to allow better compability with tools developed for the Redis ecosystem.
This is also well documented on the Dragonfly website: https://www.dragonflydb.io/docs/integrations/bullmq
1 vote -
Support pgvecto.rs as a PostgreSQL Extension
As a developer,
I want to be able to use the pgvector.rs extension (https://docs.pgvecto.rs/),
so that I can have Scalable Vector Search in PostgreSQL.1 vote -
pgbouncer
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.1 vote -
PGBouncer metrics displayed in Aiven Console Metrics page
As a Systems Administrator
I want to see PGBouncer Metrics (CPU/RAM/Network Usage) on the Aiven Console Metrics page
so that I can quickly and easily see resource utilization across both PostgreSQL and PGBouncer.1 vote -
Update max_execution_time system variable
The ability to globally enforce the maxexecutiontime system variable would be great to have
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_max_execution_time
As it would help with limiting the long running queries happening that are left unchecked.
1 vote -
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.
1 vote -
Bktree_spgist
As db admin
I want to add bktree extension for Postgres
so that I can do a similarity search based on hamming distance
In addition, this extension also includes the SP-GiST.Please see the following repository:
https://github.com/fake-name/pg-spgist_hamming1 vote -
Support Postgres Event Triggers
As developer
I want to create event triggers
so that I can react to DDL changes across the entire database.Aiven for Postgres currently does not support Event Triggers: https://www.postgresql.org/docs/16/event-triggers.html
1 vote -
Built-in Query Editor in Aiven Console for PostgreSQL
As a developer or database admin, I would like a query editor built into the Aiven Console to improve my productivity, allow a streamlined workflow, facilitate trainings, and ease of use for unfamiliar users so that I can run queries directly on the Aiven Console on the web without needing to use additional tools.
1 vote -
MySQL Audit Logging Capability
As a database administrator or developer, I would like to have audit logging capability in the system so that I can track and monitor user activities, maintain data security, and ensure compliance with regulatory requirements.
1 vote -
Display a warning when updating parameters that cannot be lowered once increased
There are parameters like the 'maxworkerprocesses' that cannot be lowered once it's been enabled and increased with the warning message: "PostgreSQL setting 'maxworkerprocesses' cannot be lowered from its current value". It would be nice to be warned prior to toggling and increasing these settings.
1 vote -
pgoutput
As a dba
I want to add the PGOUTPUT extension
so that we can use this type of logical replication
In addition, it is important as our system integration requires it to work, and it is generally better performing over test_decoding1 vote -
Admin user should access to snapshot statuses
As DEV
I want my admin user to have access to snapshot statuses over GET snapshot/status API (https://opensearch.org/docs/latest/api-reference/snapshots/get-snapshot-status/)
so that I'll be able to monitor and prevent my applications to fail because a snapshot blocks index management.1 vote
- Don't see your idea?