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

Azure Database for PostgreSQL Reviews

Vendor: Microsoft
4.3 out of 5
Post review

What is Azure Database for PostgreSQL?

Azure Database for PostgreSQL is a robust cloud solution designed to host scalable applications, manage large datasets, enable advanced analytics, and ensure data integrity through strong security features and automated backups.

Get the Database as a Service (DBaaS) Buyer's Guide and find out what your peers are saying about Azure Database for PostgreSQL and more!
Buyer's Guide
Database as a Service (DBaaS)
December 2024
Get the category report
Helped 823,875 peers since 2012

Featured reviews

Read more reviews
 
 
Key learnings from peers

Valuable Features

Azure Database for PostgreSQL delivers remarkable networking and integration, simplifies configuration, and enhances usability with flexible servers and seamless Azure service integration. Teams find the interface intuitive, optimizing easily, embedding additional value, and refining observability. Security features are well-regarded, integrating smoothly into the Azure ecosystem. OpenAI integration and vector capabilities bolster innovative applications. Improved permissions and licensing simplify management. AI features enhance competitiveness, providing a user-friendly experience without deep database expertise.
  • "Postgres has helped us innovate and stay competitive."
  • "The effective integration of Postgres with Microsoft products, especially with the inclusion of AI features in Azure AI, is significant for our applications."
  • "I rate Azure Database for PostgreSQL 10 out of 10."

Room for Improvement

Azure Database for PostgreSQL requires faster scaling with less downtime and more flexibility. Performance and storage scaling should be dynamic to enhance efficiency and reliability during peak loads. Monitoring and management tools need cost-efficiency improvements, as enabling all metrics increases expenses. Enhanced RAG extensions and knowledge graph functionality would align with competitors. Simplifying user additions without scripting and improving performance constraints like mirroring and Change Data Capture is essential for customer satisfaction.
  • "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)."
  • "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)."
  • "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."

ROI

Azure Database for PostgreSQL significantly reduces total ownership costs by at least 25 percent compared to on-premises databases, leading to enhanced ROI. Users highlight its cost-effectiveness over Redis Cache and expensive SQL server licenses. Many report decreased costs, facilitated license management, and a 40 percent increase in efficiency. There's anticipation of further cost reductions as more operations move to the cloud.

Pricing

Enterprise buyers find Azure Database for PostgreSQL's pay-as-you-go pricing model advantageous, reducing hardware investments and lowering database-related costs, as it allows for flexible scaling. The focus on Infrastructure as Code and FinOps helps manage costs efficiently. Users appreciate only paying for what is used, with some achieving up to a 60% cost reduction compared to on-premises solutions. Licensing and setup costs are generally not problematic, although some clients emphasize the need for automated cost management.
  • "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."
  • "The pricing experience is positive. Azure Database for PostgreSQL reduces the need for hardware investments, and the pay-as-you-go pricing model positively affects database-related costs by allowing us to start small and scale as needed."
  • "The pay-as-you-go pricing model plays a critical role in managing database-related costs and resource allocation. We build using Infrastructure as Code (IAC) and maintain a focus on FinOps to control Azure service costs. Some clients are pushy on price. It's critical to automate it, so we're just using it when appropriate and switching it off in certain scenarios."

Popular Use Cases

Managed service providers utilize Azure Database for PostgreSQL for diverse applications, supporting 300 customers with varying needs. PostgreSQL is chosen over MySQL or Azure SQL for its performance, flexibility, and containerization capabilities. Many prioritize it for migrations, particularly Oracle conversions. Usage spans healthcare, retail, and finance for enterprise solutions, along with reporting, awareness, and safety programs in public domains. Infrastructure teams deploy it for applications like ControlM and internal processes, employing extensions like pgvector for advanced search functionalities.

Service and Support

Azure Database for PostgreSQL users generally handle implementations internally and find Microsoft's documentation and training exceptional. Support experiences are positive, although some users rely on other database connections if needed. Comfortable with Microsoft's practical offerings, users often stay with their services. Regular feedback to the Microsoft community and communication with their engineering team provides further insights.

Deployment

Scalability

Azure Database for PostgreSQL scales efficiently with workloads without significant problems. Users highlight its capacity to handle large enterprise deployments and critical projects. SQL on Azure is noted for strong scalability in various cases. FlexServer offers necessary flexibility based on application needs.

Stability

Azure Database for PostgreSQL exhibits occasional stability issues, such as crashing during peak usage without auto-healing. Many experience fine performance with negligible latency if usage is moderate. Some rely on anecdotal evidence from developers, as they note no issues, although comprehensive statistics are lacking. Local deployment helps ensure stability without latency problems. Monitoring of uptime is ongoing to address any stability concerns.
These insights are based on the in-depth reviews provided by peers to help you make a better buying decision.
Download our Database as a Service (DBaaS) Buyer's Guide for additional reliable information.

Learn more about Azure Database for PostgreSQL

Many utilize Azure Database for PostgreSQL due to its seamless integration with other Azure services and ease of setup. It supports advanced analytics and data warehousing with powerful querying capabilities. Users appreciate its high availability, automated backups, and strong security measures like advanced threat protection and encryption. Azure Database for PostgreSQL's compatibility with standard PostgreSQL ensures a smooth migration process and minimal disruption to existing applications. However, some areas needing improvement include scalability, performance under heavy loads, monitoring tools, integration with other services, documentation, support response times, and stability during peak times. Pricing is also considered high by smaller businesses.

What are the most important features of Azure Database for PostgreSQL?
  • High Availability: Built-in redundancy and failover capabilities to ensure continuous operation.
  • Automated Backups: Regular, automated backups for data protection and recovery.
  • Scalability Options: Flexible scaling to handle varying workloads efficiently.
  • Advanced Security: Features like threat protection and encryption to safeguard data.
  • Integration with Azure Services: Seamless interoperability with other Azure tools and services.
  • Performance Metrics: Robust monitoring tools for performance tracking and optimization.
  • Simplified Management: Easy management through the Azure portal.
  • PostgreSQL Compatibility: Ensures smooth migration and minimal disruption to existing applications.
What benefits and ROI should users look for?
  • Enhanced Security: Protects sensitive data through comprehensive security features.
  • Cost Efficiency: Potential for reduced infrastructure and maintenance costs.
  • Improved Performance: Optimized querying and data processing capabilities.
  • Simplified Operations: Streamlined database management and maintenance.
  • Scalability: Ability to scale resources based on workload demand.
  • Reliability: High availability and failover support to ensure operational continuity.

In healthcare, Azure Database for PostgreSQL is often implemented to manage and analyze large patient datasets while ensuring data security and compliance with regulations. E-commerce companies utilize it to handle scalable transactions and customer data management, leveraging its integration with data analytics tools. Financial institutions employ it to securely store and process large volumes of financial data, relying on its robust security and automated backups.

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?

Product Categories

Product Categories
Database as a Service (DBaaS)