Azure Database for PostgreSQL
We would love to hear it! Please take a few minutes to submit your idea or vote up an idea submitted by another Azure Database for PostgreSQL customer. All of the feedback you share in these forums will be monitored and reviewed by the Azure Database for PostgreSQL engineering team. By suggesting or voting for ideas here, you will also be one of the first to know when we begin work on your feature requests and when we release the feature.
Remember that this site is only for feature suggestions and ideas! If you have technical questions please try our documentation, MSDN forum or StackOverflow.
-
Support for PGroonga
PGroonga is a PostgreSQL extension to use Groonga as the index, and make PostgreSQL fast full text search platform for all languages (such as Japanese and Chinese).
PGroonga: https://pgroonga.github.io/
Groonga: http://groonga.org/
8 votes -
Ability to increase max_connections
Default values are too low for our needs.
8 votes -
8 votes
-
Add "pgpointcloud" extension support.
Request for support for the pgpointcloud extension in Azure PostgreSQL databases.
https://github.com/pgpointcloud/pointcloud
Would also be useful to have the optional compression features included. These require libght (https://github.com/pramsey/libght/) and lazperf (https://github.com/hobu/laz-perf).
8 votes -
Support Proximity Placement Group in PostgreSQL - Flexible Server
The unique reason we had to build manually or own PostgreSQL with VMs instead of using Azure PostgreSQL as a service was the lack of support of proximity placement groups.
Now that you are developing flexible server options based in "normal" VM It will be great it PPG are supported so we can address the "high" latency problems we had with the service.
7 votes -
Correct handling of cancel query request (from client)
I have been using "normal" postgres for many years now and I have become quite used to being able to cancel (ctrl-c) long-running queries I started from a client (psql).
When I try this when I am connected to an Azure postgres database, psql states that the signal was sent, but the query is not cancelled. To cancel it, I have to open another session and run a pgcancelbackend(pid) on it.Please implement support for handling Ctrl-c signals to cancel queries.
Update:
I raised this as a support ticket and was informed by the support-engineer that this was…7 votes -
Execute SQL scripts during ARM Template Deployments
After deploying a postgreSQL service using an ARM template, in order to configure my databases, roles, etc., I have to execute a script after I have deployed the service.
I'd like a way to include a SQL script at time of deploying my ARM template.
7 votes -
pgTAP support for application testing
We are working on migrating our app to Azure, and our app has unit/regression tests with using pgTAP [1].
I would like Azure PostgreSQL to support pgTAP to allow us for application compatibility test.
7 votes -
Implement PL/.NET Core for Stored Procedures, Triggers, and Functions in PostgreSQL
Implement PL/.NET Core support which will allow for Stored Procedures, Triggers, and Functions in PostgreSQL to be written in .NET Core
7 votes -
Oracle "oracle_fdw"
Please include oracle "oracle_fdw" in order to support oracle connectivity
6 votes -
Include support for PLJAVA extension
Include support for PLJAVA extension to be able to write stored procedures, triggers, functions in Java
6 votes -
Make PostgreSQL on Azure support usable speeds and not be slow
PostgreSQL on Azure is very outdated and extremely slow. It's very much unusable like this and we ended up moving to our own PostgreSQL container that don't have these issue. Please clarify that
6 votes -
MADlib
Machine learning, statistics and analytics for data scientists
http://madlib.incubator.apache.org/6 votes -
neo4j_fdw extension
Include neo4j_fdw foreign data wrapper for Neo4j Graph Database
5 votes -
Support for PostgreSQL 13
Once version 13 is out, it would be good to get it supported as documentation claims azure will support every major ver (and 12 is still not supported)
5 votes -
Automatic failover between regions
Whenever the databases on one region are down, allow to failover automatically to another region without changing the connections string
5 votes -
Include pg_repack feature for azure database of postgresql
It will be helpful if we have pgrepack feature in azure database for postgresql to handle bloat.vacuum full will place an exclusive lock on the table and until the vacuum full is completed the transactions related to that table will be held if the vacuum full is performed at table level.So pgrepack is the alternate option where the reorg of table can be performed with out impacting any ongoing transactions.Performing repack during the time when there are less number of transactions to that table will decrease the overhead and can be able to handle bloat in efficient way.
5 votes -
Support upgrading major versions via Replication
Upgrading Data via Replication is documented as a method in the PostgreSQL docs.
When creating a read replica in the Azure Portal it is not possible to change the version (I assume it uses the same version as the master).
Please allow selecting a version when creating a replica so that this upgrade method would be possible.
18.6.3. Upgrading Data via Replication
https://www.postgresql.org/docs/current/upgrading.html5 votes -
oracle_fdw extension
Provides a Foreign Data Wrapper for easy and efficient access to Oracle databases, including pushdown of WHERE conditions as well as comprehensive EXPLAIN and ANALYZE support.
5 votes -
Ability to shrink storage when restoring
We would like to shrink the allocated (max) storage when we restore a PaaS to create another environment. This would be especially interesting to create Test environments from Production environments with large unused storage (due to the provisioning of a big IOPS bandwith for performance).
5 votes
- Don't see your idea?