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
Post review

Pros & Cons summary

Azure Database for PostgreSQL offers robust networking capabilities and flexible configurations, enhancing database uptime and integration with Azure services. It accelerates application development and integrates effectively with Microsoft products, yet faces stability and performance constraints. Improvements are needed in ease of integration with Azure AI, RAG extensions, and user management. Recognized as an industry leader, it supports UK infrastructure but lacks auto-healing and advanced indexing tools, and faces challenges in mirroring and CDC functionalities.

Buyer's Guide

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

Prominent pros & cons

PROS

Azure Database for PostgreSQL offers robust networking capabilities, enabling seamless integration with other Azure services.
Improved database uptime, especially through redundant configuration capabilities, enhances failovers and read-only configurations.
Provides ease of use and optimization, facilitating faster application development.
Integration with Microsoft products, including AI features, significantly enhances application performance.
Supported by PostgreSQL, a powerful industry leader, which aids in critical infrastructure development and innovation.

CONS

There is a stability issue where, if database usage peaks quickly, it may crash and require intervention to restore functionality. It does not auto-heal in such situations.
Azure Database for PostgreSQL lacks comprehensive RAG extensions, currently offering only vector search without support for knowledge graph functionalities like Neo4j.
Indexing tools are limited in comparison to other vector databases.
Improving integration with critical services like Azure OpenAI and cognitive services would be beneficial.
Performance constraints exist, particularly in the areas of mirroring and Change Data Capture (CDC).
 

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.
Read full review
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.
Read full review
reviewer2595954 - 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.
Read full review
Buyer's Guide
Database as a Service (DBaaS)
December 2024
Download Free Report
Find out what your peers are saying about Microsoft, Oracle, Yugabyte and others in Database as a Service (DBaaS). Updated: December 2024.
DOWNLOAD NOW
823,875 professionals have used our research since 2012.
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.
Read full review
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.
Read full review
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.
Read full review
 

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.
Read full review
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.
Read full review
reviewer2595954 - 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.
Read full review
Buyer's Guide
Database as a Service (DBaaS)
December 2024
Download Free Report
Find out what your peers are saying about Microsoft, Oracle, Yugabyte and others in Database as a Service (DBaaS). Updated: December 2024.
DOWNLOAD NOW
823,875 professionals have used our research since 2012.
LL
Nov 20, 2024
They can offer more RAG extensions. Currently, it only has the vector search.
Read full review
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).
Read full review
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.
Read full review

Product Categories

Product Categories
Database as a Service (DBaaS)

Product Categories

Product Categories
Database as a Service (DBaaS)
Related questions
  • 5
When evaluating Database as a Service, what aspect do you think is the most important to look for?
  • 10
What would be the best application SQL optimizer over the WAN?
  • 52
Which database is the best for session cashing?
  • 158
What is the biggest difference between Google BigQuery and Oracle Database as Service?
  • 32
Which low-code (no-code) database solution do you prefer?
  • 10
Which databases are supported under DBaaS solutions?
  • 0
Why is Database as a Service important for companies?