93 results found
-
Support PLV8 on versions of Postgres greater than 10
As Software Developer
I want to use PLV8 on Postgres 16
so that I can use Javascript as a procedural language on my PG 16 service.2 votes -
Expose the metric filecount_size_bytes
As backend and DevOps engineer / SRM, I want to be able to visualize in Grafana metrics related to WAL files buildup due to lagging or missing replication slots.
This will help us debug WAL bloat which might exhaust the disk space and better understand the cause.Mainly the metric
filecount_size_byteswill be useful. Also any metric that would allow us to monitor per database service:
1. Total WAL size.
2. Size of WAL retained due to replication lag.
3. Rate in which we consume the WAL for the replication over time (connector consumption rate).
4. Rate in which we…2 votes -
Recreation of replication slot after power cycle
As a DBA or developer,
I want to be able to stop/start my services without losing replication slots
so that I can resume my logical replication flows even after a power cycle.Similar recreation is currently done during nodes failover: https://aiven.io/blog/aiven-for-pg-recreates-logical-replication-slots
2 votes -
Change the default SSL Mode
Make it possible to change the default SSL mode.
This way, by setting this value to "verify-full", we can make it so that anyone trying to connect to the database MUST have the CA certificate.Because currently, what's the point of the CA certificate if it is not mandatory?
2 votes -
PostgreSQL logging JSON format with OpenSearch integration
As DBA I want to have better logging using the PostgreSQL v15 logging feature to save the logs in JSON format so that I can integrate these logs in OpenSearch and provide better readability of these logs.
This will provide 2 things:
1 - Parse of the fields of the log entries -> give more capabilities searching the logs - easily filter some field like user/database/application name
2 - Multi line queries in one log entry -> right now, multi line queries saves each line in a different log entry, which is very hard to filter a full query since…2 votes -
Expose pg_stat_statements.track_planning Configuration Parameter
As a database administrator, platform engineer or developer
I want to be able to enable the pgstatstatements.track_planning configuration parameter.2 votes -
Support h3-pg as a PostgreSQL Extension
As a database administrator or developer, I would like to have H3 Hexagonal Hierarchical Geospatial Indexing System in PostgreSQL via h3-pg extension so that I can efficiently index and analyze geospatial data, including creating heatmaps and performing various spatial analyses, enhancing location-based decision-making for applications and services.
2 votes -
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 for being able to adjust the checkpoint_timeout parameter
Requesting to allow the parameter to be adjustable so that WAL flush is more frequent and allow faster after-crash recovery option
1 vote -
Release pg_repack v1.5.1 extension
As a database administrator, developer or PO for Cloud Operations,
I would like the pgrepack extension to be updated to version 1.5.1,
to fix the issue we are encountering in version 1.5.0: https://github.com/reorg/pgrepack/issues/380 and to be compatible with my infrastructure1 vote -
Support for pgvector 0.8.0
Our application is experiencing critical intermittent failures directly related to known issues in pgvector versions prior to 0.8.0. Needing pgvector versions greater than 0.8.0 to address the known issues.
1 vote -
pg_curl
I would like to set up cron jobs that make curl requests.
1 vote -
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 -
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 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 -
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
- Don't see your idea?