140 results found
-
pgrouting
Since pgrouting 3.4 the function pgr_trspVia is available.
Given a list of vertices and a graph, this function is equivalent to finding the shortest path between vertex(i) and vertex(i+1) for all i < sizeof(vertices) trying not to use restricted paths.
The paths represents the sections of the route.
The general algorithm is as follows:
Execute a pgrdijkstraVia - Proposed.
For the set of sub paths of the solution that pass through a restriction then
Execute the TRSP algorithm with restrictions for the paths.
NOTE when this is done, Uturnonedge flag is ignored.1 vote -
Support VectorChord extension on Postgres
As developer,
I want to deploy a cost-efficient and fast vector database
so that I can develop a fast-serving RAG application with large datasets.https://blog.vectorchord.ai/vectorchord-store-400k-vectors-for-1-in-postgresql
1 vote -
Enhancing Database Search with PGroonga for Better Efficiency
As a database administrator, I want to have the option to use the PGroonga extension so that I can take advantage of advanced text search capabilities, including full-text search with regular expressions and n-gram tokenization.
In addition, PGroonga offers better performance for certain types of search operations, which is especially important for handling large datasets efficiently and improving the search functionality in applications.1 vote -
Support pg_embedding as a PostgreSQL extension
As a software engineer
I want to use pg_embedding
so that I can perform faster (20x) vector searches in PostgreSQL.
In addition, ML use cases are everywhere now and reducing search times will impact many projects.1 vote -
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 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.3 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 for Apache Age PostgreSQL Extension
As a developer or database administrator our customer is planning to use Apache Age (https://github.com/apache/age) in their Managed Service for Timescale (MST) deployments which is provided by Aiven.
I cannot see this extension in the list but is there any way or plan to add this into the managed services.Thanks!
1 vote -
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 -
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 -
Support postgresql_anomymizer as a PostgreSQL Extension
As a data privacy officer, database administrator, data analyst/researcher, or compliance officer, I would like the ability to anonymize sensitive data in the database by masking or replacing personally identifiable information (PII) or commercially sensitive data so that I can protect individuals' privacy and ensure compliance with data protection regulations such as HIPAA and GDPR.
31 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.
60 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 -
PostgreSQL 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.
42 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 -
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
- Don't see your idea?