84 results found
-
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 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 -
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 -
pgbouncer metrics prometheus endpoint support
As a DBA or SRE, I want to be able to monitor more pgbouncer metrics. Please add support of pgbouncer input plugin for telegraf to expose prometheus endpoint
https://github.com/influxdata/telegraf/tree/master/plugins/inputs/pgbouncer8 votes -
Support Hydra as a PostgreSQL Extension
As a database administrator or developer, I would like to query and analyze large volumes of data efficiently in PostgreSQL as a column-oriented database so that I can achieve fast and parallelized analytics without extensive code changes, reducing processing time from weeks to minutes.
8 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 -
Release pg_partman Version 5.0.0 as a PostgreSQL Extension
As a database administrator, developer or PO for Cloud Operations,
I would like the pg_partman extension to be updated to version 5.0.0,
so that I can keep my infrastructure compatible.7 votes -
Allow Safeguarded PostgreSQL Settings to be Lowered
As a database administrator or developer,
I would like to be able to lower the previously increased, safeguarded PostgreSQL settings,
so that I would be able to optimize the performance of my service according to its current state.7 votes -
Increased Storage for Databases
As a developer or database administrator,
I want to be able to create storage plans with a capacity up to 64 TB using persistent SSD storage,
so that I can scale up my storage as I grow my business towards enterprise.7 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.
6 votes -
Access to the pg_monitor role
As a DBA
I want to access the pg_monitor role
so that I can integrate with my in-house monitoring solution
In addition, this could be via aiven-extras or an advanced configuration if necessary6 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 -
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 -
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 orafce as a PostgreSQL Extension
As a database administrator or developer, I would like to utilize the Orafce extension in PostgreSQL so that I can easily incorporate familiar database functions and packages from other systems, simplifying the migration process and ensuring compatibility with existing applications and data structures.
5 votes -
Support for scram
Aiven end customers and their security teams are asking for support for more modern authentication methods, mainly scram-sha256. Scram has been supported by Postgres since version 10. Introducing the support in Aiven platform would allow customers to enchance their database security.
5 votes -
Configurable random_page_cost parameter in PostgreSQL Settings
As a customer,
I want to be able to configurerandom_page_cost
and optionallyseq_page_cost
in Postgres advanced configurations in order to influence the query planner.4 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 -
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
- Don't see your idea?