Try our new research platform with insights from 80,000+ expert users
Azure Database for PostgreSQL Logo

Azure Database for PostgreSQL pros and cons

Vendor: Microsoft
4.3 out of 5

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Networking capabilities of Azure Database for PostgreSQL enable seamless integration with other Azure services, greatly enhancing organizational efficiency.
Redundant configuration and flexible server capabilities improve database uptime, allowing for failovers and read-only configurations.
PostgreSQL is recognized for its power and reliability, supporting critical infrastructure and driving innovation in the UK.
The inclusion of AI extensions in Azure AI is a significant advantage, enabling enhanced application performance and competitiveness.
Ease of integration with Microsoft products like SharePoint, PowerApps, and PowerFlow enhances Azure Database's appeal, simplifying licensing and use.

CONS

Azure Database for PostgreSQL has stability issues where rapid usage peaks may cause crashes requiring manual intervention as it lacks auto-heal functionality.
It offers limited RAG extensions, having only vector search, and lacks support for knowledge graph functionalities like Neo4j.
Critical integration with Azure OpenAI service could be simplified for better ease of use.
Performance constraints exist, particularly in the areas of mirroring and Change Data Capture.
Support is not satisfactory, with room for significant improvement.
 

Azure Database for PostgreSQL Pros review quotes

Daniel Amini - PeerSpot reviewer
Nov 20, 2024
PostgresSQL is acknowledged as an incredibly powerful industry leader. We've built critical pieces of national infrastructure in the UK that rely on Postgres. A version of Postgres on Azure that's easy to adopt enables us to innovate. The addition of AI extensions is even more exciting. It's a significant opportunity for us.
Wesley Haakman - PeerSpot reviewer
Nov 20, 2024
The most valuable features of Azure Database for PostgreSQL are its networking capabilities, which allow for integration with other Azure services.
NR
Mar 27, 2025
Overall, Azure Database for PostgreSQL has been good for us.
Learn what your peers think about Azure Database for PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
845,406 professionals have used our research since 2012.
Jan Pinheiro - PeerSpot reviewer
Nov 20, 2024
In terms of integration, we already have SharePoint online, and we're starting to explore PowerApps and PowerFlow. It's all seamless. The ease of integrating SQL and licensing purposes plays a significant role, making it a comfortable choice for the organization.
LL
Nov 20, 2024
It is easy to use and optimize. It is very easy for us to understand how a chopped chunk can be translated into embedding.
Manikyam Thukkapuram - PeerSpot reviewer
Nov 21, 2024
The effective integration of Postgres with Microsoft products, especially with the inclusion of AI features in Azure AI, is significant for our applications.
reviewer2596230 - PeerSpot reviewer
Nov 21, 2024
We use PostgreSQL to speed up application development. Our applications are ready sooner because we don't need to depend on other database teams.
US
Feb 3, 2025
The operational efficiency of Azure Database for PostgreSQL is good.
GG
Jan 23, 2025
Backups are easy, resizing is quick, and the query analyzers help me find out what's happening in each of the queries.
 

Azure Database for PostgreSQL Cons review quotes

Daniel Amini - PeerSpot reviewer
Nov 20, 2024
The critical service is the Azure OpenAI service. It would help to make it simpler and easier to integrate with that or cognitive services.
Wesley Haakman - PeerSpot reviewer
Nov 20, 2024
There is a stability issue where, if the database usage peaks quickly, it may crash and require intervention to restore functionality. It does not auto-heal or self-heal in such situations.
NR
Mar 27, 2025
While the flexibility of the server for financial reasons is understandable, better switching between primary and backup would make transitions smoother.
Learn what your peers think about Azure Database for PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
845,406 professionals have used our research since 2012.
Jan Pinheiro - PeerSpot reviewer
Nov 20, 2024
Perhaps a minor improvement could be made in simplifying user additions, allowing for an easier process rather than scripting it out. However, scripting is not a significant issue.
LL
Nov 20, 2024
They can offer more RAG extensions. Currently, it only has the vector search.
Manikyam Thukkapuram - PeerSpot reviewer
Nov 21, 2024
Performance is one area that has constraints for our customers. I believe there could be improvements in the mirroring part and Change Data Capture (CDC).
reviewer2596230 - PeerSpot reviewer
Nov 21, 2024
There aren't any notable areas for improvement that I could see. PostgreSQL was self-sufficient with no need for additional database knowledge to maintain it.
US
Feb 3, 2025
In the future, I would like to see anomaly detection.
GG
Jan 23, 2025
Support can certainly get better.