134 results found
-
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.22 votes -
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…
12 votes -
Enable Configuration of log_parameter_max_length and log_parameter_max_length_on_error
As a Database Administrator,
I want to have the ability to configure the PostgreSQL parameters
log_parameter_max_lengthandlog_parameter_max_length_on_errorwithin Aiven's platform,so that I can prevent sensitive data from being exposed in database logs, especially during the logging of slow queries.
In addition, enabling this configuration is crucial for maintaining compliance with data protection regulations and upholding the privacy standards expected.
12 votes -
postgresql
As Developper
I want to configure Polish language
so that I can use PostgreSQL's text search feature for autocomplete functionality
In addition, find below some references to describe the configuration steps :2 votes -
PGbouncer as a service to point at multiple read-replicas
As a application user,
I want to instantiate a Single PG Bouncer service on Aiven to point across multiple READ-Replica Nodes so that I can it automatically handles the pooling of read connections.3 votes -
pg_mooncake
I would like to be able to use data lakes from postgres and the pg_mooncake extension enables that.
2 votes -
postgresql uri
As a developer
I want to copy-paste the Service URI from the Aiven console
so that I can use it in Java JDBC connection strings as is without changing postgres:// to postgresql:// (see https://jdbc.postgresql.org/documentation/use/).
In addition, the official docs allow both postgresql:// and postgres://, but JDBC does not seem to honour this: https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING-URIS3 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 -
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.
7 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 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.
11 votes -
Multi-Region Standby Capability with Automatic Promotion for Relational Databases
As a database administrator or developer, I would like multi-region standby capability for my PostgreSQL and MySQL databases so that I can ensure high-availability and business continuity by maintaining standbys across different regions, enabling automatic promotion in the event of a region-wide outage.
47 votes -
pg_curl
I would like to set up cron jobs that make curl requests.
1 vote -
Allow updating the table_definition_cache and table_open_cache MySQL parameters
Setting these variables allows the ability to configure the cache parameter to avoid workload issues with prepared statement issues
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 -
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 -
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
- Don't see your idea?