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.
-
Ability to restore to same database name
Ability to run a point in time restore to same database name rather than restoring to a new instance.
2 votes -
Point in time restore to include HBA and server parameters
When restoring to a point in time, HBA settings and server parameters such as search_path are not included on the new server. It would be nice for the restore to include this configuration.
2 votes -
zhparser extension for Chinese Full Text Search
We would like to be able to use https://github.com/amutu/zhparser in order to implement Chinese Full Text Search.
2 votes -
Great GUI Tool for Writing/Developing Postgres Queries
A tool focused on postgres developers writing sql. No query builders, no admin/management tools cluttering everything up. Each window only needs to connect to one database, show the tables and their columns. A nice big button and intelligent keybinding(e.g. shift+enter) for executing queries. Production databases should have red outline/window borders or some danger indication. Config the connection with a file, no need for ui. Postgres only and support it's unique datatypes json/array/etc really well, and no jdbc/jvm requirements. And very importantly show stacked results, because I can't tell you how important it is when working to see the results from…
2 votes -
Better grouping of server parameters
Would be great if server parameters were logically grouped together (rather than just being sorted alphabetically). For example, timeout settings together, logging settings together etc.
2 votesThanks for your feedback. That could be a helpful UI change for the Azure portal. Currently it’s unplanned, but we can revisit it in the future if there’s a high demand.
We also support search over the list of parameters to get to the one you need.
-
support the pg_hashids extension
Please add the following extension to postgres: https://hashids.org/postgresql/ it is a library to enable generating short slugs from integers. and the GitHub for it: https://github.com/iCyberon/pg_hashids
Thank you
1 vote -
Resource Governace for CPU and Memory
We are running a multi-tenant system leveraging Azure PostgreSQL.
During heavy load, one Tenant can impact the system to a point where other databases are effected.Wondering if you are planning to support some type of resource governance in the future similar to Azure SQL
https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor-resource-pool?view=sql-server-2017I realize it wont be the same implementation, but maybe a new connectionstring parameter that could be set to limit CPU/Memory could be a start?
1 vote -
Reader Role can view Query Text
On AZ PostgeSQL Performance Insight, the role of Reader can view everything but not “query text”,
so basically like most of things in Azure we believe that Reader role should also be able to
view query text. And that is the issue and needs to be fixed in future releases.CSS, Requested by Customer
1 vote -
Azure VNet in paired region
For Azure SQL, service endpoint should allow traffic not only within a virtual network's region but also extend to include the paired region where the virtual network is deployed.
(Idea submitted by Manish Kumar from the engineering group of Azure Database for PostgreSQL/MySQL service on behalf of one of our customers and in order to elicit feedback from other customers and users).
1 vote -
Stop/start server
Gaging interest for being able to stop a server when it is not being used and restart it when needed.
1 vote -
Rename server
Gaging interest for being able to rename a server/instance.
For instance some customers shared that the naming convention they use for servers changes as a server moves from one stage of its lifecycle to another (test -> staging -> prod for instance)
1 vote -
Target for Data Factory (ADF)
Data Factory supports PostgreSQL and Azure PostgreSQL as sources. Please add them as targets.
1 vote -
Native Python and R support - extensions plpythonu, plpython2u, plpython3u
Please support extensions plpythonu, plpython2u, plpython3u so functions etc. can have Python code.
Similar request for R support with extensions like PL/R
1 vote -
Allow Event Triggers to be created
I am working with multiple users on shared tables. As the users belong to a dedicated role "pgpublish" I am in the need to run "ALTER TABLE "MYcoolSchema"."CoolNewTable" OWNER TO pgpublish;" on every new table which we create manually.
As I want to have any new table owned by the role pgpublish instead of the user role I want to to create a trigger function and a trigger event to change table owner automatically (as described here: https://blog.hagander.net/setting-owner-at-create-table-237/). Unfortunately I can't create trigger events as I am not a superuser nor do I have the credentials for a SU…1 vote -
effective_cache_size
You should allow tuning of memory-related parameters. I have a 15GB server and the effective_cache_size is 1536MB; it should be eight times as high. Without tuning these parameters my application is simply too slow to run on your environment.
1 vote -
1 vote
-
Enable the Pgstattuple Extension
The extension pgstattuple is best used when you suspect something is amiss with the performance of a query and you suspect bloat.
The pgstattuple is the most accurate way to determine the bloat in a particular table or index.
I would like the ability to run the command manually as part of my debugging exercises.
It is not required that pgstattuple be run as a service because it is intrusive.
1 vote -
Provide actual memory being used (in GB) in Azure Monitor
Provide actual memory being used (in GB) in Azure Monitor in addition to % memory used. The customer scenario is for the Persona of a QA/Test professional. Actual memory used is much more useful than % used as it related to determining the quality of a product / service. % used is tailored to SRE/Ops persona.
1 vote -
Ability to use PG FDW to access one PG server from another w/o opening the firewall to all of Azure
I'd like a way to use Postgres foreign data wrapper (FDW) which is supported today to access one Azure DB for Postgres server from another, without opening the firewall on the first server to all of Azure.
1 vote -
Transactional DB with Analytics
AWS announced an analytics extension to Aurora for MySQL with postgreSQL to follow:
https://aws.amazon.com/blogs/aws/new-parallel-query-for-amazon-aurora/" ...you can run a mix of analytical and transactional queries simultaneously on the same table while maintaining high throughput for both types of queries. "
This would be a tremendous feature that my company could exploit at large scale.
1 vote
- Don't see your idea?