https://github.com/cybertec-postgresql/pg_squeeze
pg_squeeze is an extension that removes unused space from a table and
optionally sorts tuples according to particular index (as if CLUSTER [2]
command was executed concurrently with regular reads / writes). In fact we try
to replace pg_repack [1] extension.

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

Users can decide when scheduled maintenance starts from in AWS.
e.g. Maintenance refers to the application of OS and database security patches.

Please be able to control schedule the maintenance in Azure Database for PostgreSQL from the users . It is problem that unexpected connection failures by maintenance in Azure Database.
For pre-planned maintenance, the convenience of users will be improved , if schedule the maintenance can be controlled.

AWS's Resource
How do I minimize downtime during required Amazon RDS maintenance?
URL: https://aws.amazon.com/premiumsupport/knowledge-center/rds-required-maintenance/?nc1=h_ls

Maintaining a DB Instance
URL: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Maintenance.html

It's a perfect fit together with timescaledb-extension if you have prometheus running in AKS

Please upgrade PostGIS 2.4 to PostGIS 2.5 on PostgreSQL 10. Several new features were introduced in PostGIS 2.5 which speeds up spatial calculations.

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/

Can the 'azure_pg_admin' role be enhanced so that

ERROR: permission denied: "my-trigger-name" is a system trigger

is not encountered when executing

ALTER TABLE “my_table” DISABLE TRIGGER ALL

. The system trigger in question is one associated with a foreign key and the assocated triggers are system triggers.

RUM indexes are better suited for full-text search on PostgreSQL: https://akorotkov.github.io/blog/2018/05/21/fulltext-search-made-almost-right/.

Just wanted to upgrade the TimescaleDB extension from the current v1.1.1 to v1.3 or higher to be able to utilize the Continuous Aggregates feature.

Even though Azure DB for PostgreSQL provides secure connection, Applications on ARO needs to access Azure DB for PostgreSQL via internet.

Currently, VNET for ARO doesn't allow any modification, therefore, there is no option avoiding going through internet when applications connect to Azure DB for PostgreSQL.

There is no point in deploying a DB container on ARO. The user needs to consider how to manage DB.

If ARO allows modifying VNET creating Service endpoint for Azure DB for PostgreSQL, it could provide more secure route and low latency connections as well.

PostGIS 3.0 is currently in alpha. It adds support for parallels processing of spatial queries which drastically increases the performance of spatial queries and makes PostGIS more inline with other advanced spatial databases. Please upgrade to this version of PostGIS when it is fully released.

Azure team edit: I' creating this new idea on behalf of a customer to separate it from the votes for Citus on Azure Database for PostgreSQL. If you're interested in Citus columnar datastore (link below), please vote for this idea.
++++

I need this to do big-ish data things:

https://www.citusdata.com/blog/2014/04/03/columnar-store-for-analytics/

I am a huge fan of postgresql for data warehousing, and this is a key thing for having the ability to summary large tables quickly.

It would be great to have the ip4r extension available in the Azure Database for PostgreSQL service. We already use this extension in our self-managed psql service to use IP addresses as native objects. It is very useful for some IPAM engines like nipapd, etc.

For more information about this extension: https://github.com/RhodiumToad/ip4r

It'd be really useful to not have to rely on DB users for authentication but allow integration with AAD. That way we can enforce password complexity, expiry etc which can't be done with native users.

It would be great if we could either use pg_basebackup as well as pg_dump to take backup or the ability to replica from the Azure Master to our own db instance (either a VM on Azure or on-premise).

This would mean creating replication role slots under the Connection security tab.

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.

locetion