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

Azure Database for PostgreSQL enhances networking capabilities for integration with other Azure services.
Organizations experience improved database uptime due to flexible server configurations, enabling failovers and read-only setups.
Ease of use facilitates application development, reducing dependency on other database teams.
Effective integration with Microsoft products, along with AI features, supports innovation and competitiveness.
Operational efficiency is supported by easy backups, quick resizing, and helpful query analyzers.

CONS

There are stability issues when database usage peaks quickly, potentially causing crashes and requiring intervention to restore functionality, and it lacks auto-heal capabilities.
It currently offers limited RAG extensions, only supporting vector search, and does not support knowledge graph functionalities like Neo4j.
There are performance constraints, particularly in mirroring and Change Data Capture (CDC).
Support could be significantly improved, currently rated at a five out of ten.
There is an interest in adding future anomaly detection features.
 

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.
842,466 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.
842,466 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.