93 results found
-
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 -
Instant database forking / branching
As developer
I want to fork databases as quickly as possible
so that I can start developing new features immediately and run fast automated tests as a part of my CI/CD.
In addition, this is especially important for larger database instances which can take a lot time to do a full copy of the entire dataset.Also known as copy on write or database branching.
3 votes -
Support pg_profile as a PostgreSQL Extension
As a database administrator or developer,
I would like to utilize the pg_profile extension in PostgreSQL,
so that I would be able to identify the most resource intensive activities in my databases.8 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 -
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 -
pgbouncer logging
As a database administrator or developer, I would like to see PgBouncer logging.
At minimal I should be able to see connection pool creation/deletion/changes and all outbound clients connected to which pool with source IPs.
1. pgbouncer logs should be available by "avn service logs" and aiven console.
2. pgbouncer logs should be available with rsyslog integration to 3rd parties.
3. ideally logging level can be controlled by pg service config parameter pg.logerrorverbosity
bonus: pgbouncer stats ingested into logging.15 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 High Availability Read-Replica Services
As a site reliability engineer,
I want to be able to create a highly available read-replica service,
so that I can use it in the critical path of my application without availability being affected by loss of a single node.
In addition, this can currently be achieved via at least two separate read-replica services (currently plans are limited to those with only one node) and appropriate client configuration, but Aiven should be able to do this for me instead.13 votes -
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 -
Configurable random_page_cost parameter in PostgreSQL Settings
As a customer,
I want to be able to configurerandom_page_costand optionallyseq_page_costin Postgres advanced configurations in order to influence the query planner.4 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 -
LDAP Authentication Support for PostgreSQL
As a database administrator or developer,
I would like to integrate LDAP authentication with PostgreSQL,
So that user management becomes centralized through existing LDAP services like ActiveDirectory, enhancing security, simplifying authentication, and eliminating the need for separate authentication methods.16 votes -
In-Place Major Upgrades on Standbys and Read-Replicas for PostgreSQL
As a database administrator or developer, I would like to perform in-place major upgrades on standby nodes and read-replicas for PostgreSQL so that the whole upgrade window is considerably shorter, resulting in increased high-availability for standbys and improved availability for read replicas. This feature will also alleviate any bottlenecks caused by the quorum sync replication, enhancing the overall database system's efficiency and resilience.
11 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
8 votes -
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 -
Kerberos Authentication Support for PostgreSQL
As a database administrator or developer,
I would like to integrate Kerberos authentication with PostgreSQL,
So that user management becomes centralized through existing Kerberos services like ActiveDirectory, enhancing security, simplifying authentication, and eliminating the need for separate authentication methods.3 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 -
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 -
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
- Don't see your idea?