103 results found
-
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 -
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 -
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: 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 -
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 -
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 -
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 postgres extension ip4r
As developer,
I want to use the ip4r extension as the built-in IP address types in Postgres work okay for many applications, but are lacking when it comes to applications that heavily work with IPs, like ours. ip4r adds several IP types with expanded functionalities that enable us to perform far more efficient "IP in range" type lookups, as well as tracking IP ranges that don't fall neatly in CIDR boundaries, plus general performance improvements. Very useful for our malicious IP threat feed service, abuseipdb.com, as you can imagine.2 votes -
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 -
Support pgai as a PostgreSQL Extension
As a developer, I would like to simplify the process of building search and Retrieval Augmented Generation (RAG) AI applications with PostgreSQL so that embedding and generation AI models are closer to the database, enabling me to create embeddings, retrieve LLM chat completions, generate responses, and reason over data directly within SQL queries.
3 votes -
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 -
Ability to adjust the lower_case_table_names setting for MySQL
As a database administrator, I want the option to be able to set the lowercasetablenames MySQL parameter in the event of migration requiring the lowercasetablenames is different than 0
2 votes -
Support pgvectorscale as a PostgreSQL Extension
As a developer,
I want to be able to perform efficient vector similarity and embeddings techniques directly in PostgreSQL, so that I can enable efficient handling of high-dimensional vector data within the PostgreSQL database for tasks like similarity search and machine learning.Pgvectorscale is an open-source PostgreSQL extension that builds on pgvector, enabling greater performance and scalability.
https://www.timescale.com/blog/pgvector-is-now-as-fast-as-pinecone-at-75-less-cost/
https://github.com/timescale/pgvectorscale2 votes -
Support oracle_fdw as a PostgreSQL Extension
As a database administrator or developer, I would like to integrate PostgreSQL with Oracle databases using the oracle_fdw extension so that I can seamlessly access data in Oracle databases from within PostgreSQL using standard SQL queries. This feature simplifies data integration and allows for efficient cross-database operations without the need for complex data migration processes.
3 votes -
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 -
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 -
Expose MySQL slow query logs in service logs
Currently, MySQL slow query logs are stored in the mysql.slow_log table. Adding an option to redirect those logs into service logs would allow log integrations, like OpenSearch, to pick those up and give customers greater value and flexibility.
It would implicitly solve the following:
https://ideas.aiven.io/forums/951280-operational-databases/suggestions/46266829-allow-mysql-slow-query-log-on-read-only-replicas4 votes
- Don't see your idea?