Azure Database for PostgreSQL Reviews

My main use cases for Azure Database for PostgreSQL are application support, mostly integration with applications.

Azure Database for PostgreSQL has been able to influence my application development process or my customer's application development processes by knowing that at least the forecasted performance you will get out of the database, it becomes a top choice. When thinking about it from a business requirement perspective and forecasting or estimating the tools you want to implement, it comes to mind because of the out-of-the-box experience around performance.

What I appreciate most about Azure Database for PostgreSQL is its performance; I would say that is probably its speed and performance and how it interacts with applications.

The performance of Azure Database for PostgreSQL is very good because compared to other databases, an application talking to a database depends on performance and reaction time being very important. What I have found with client feedback is that it is stable from where it used to be, an evolution. In terms of application responsiveness, it is excellent.

The integration of Azure Database for PostgreSQL with other Azure services has impacted my overall cloud strategy in a positive way. Azure Database for PostgreSQL is a critical component of a whole strategy. Considering that it is part of that whole strategy, it has been very impactful. However, it is not the only thing. When thinking about a strategy or a product, a product is more than just a database. The database is an integral part but the product has to do with the logical layer, the application, the data, and the security aspect, the foundational aspect like the infrastructure and so forth. It is definitely an integral part of the whole holistic toolset or component.

The scalability ability of Azure Database for PostgreSQL is able to scale big workloads. That is the reason why it is at its maturity level now and is a go-to database. The kinks have been worked out over the years. It is at a stage where it is a go-to solution when thinking about scaling across regions and scaling from a performance perspective, horizontal scaling is available.

I am not sure how Azure Database for PostgreSQL can be improved from my perspective. It is not still there from my purview, so it is not really a fair assessment because to me, before it becomes a trend, I have to see it in action or see either the good, bad or ugly over a few instances. I really cannot comment yet on that because it is still at infancy, at least for me.

I do not know if there is anything I would enhance of what is already existing within Azure Database for PostgreSQL. It is a database, and it is always nice to be more reactive in terms of performance. Performance is an evolution. As you are gracious for performance today, it becomes the standard and becomes the new bottom. It is almost as though we crave for more, and it is how we live as a society. What is considered excellent today, if you stay there as an innovator as Microsoft, it will become stale tomorrow. The simple answer is yes, the industry always craves the next advancement. What is better? Make it faster, make it more reactive. That would probably be my answer there.

The performance of Azure Database for PostgreSQL is very good because compared to other databases, an application talking to a database depends on performance and reaction time being very important. What I have found with client feedback is that it is stable from where it used to be, an evolution. In terms of application responsiveness, it is excellent.

I do not see any negative aspects from what I have seen of Azure Database for PostgreSQL platform. It has come a long way. There were some concerns around performance years ago. For the last few years, I have not heard anything. It is the go-to database if seeking performance and capacity. Bug fixes and such things are not really top of mind as an architect or for my clients as decision-makers. They do not think about whether something may not work or whether it is faulty. I think we have passed that stage in terms of concerns around performance and security. It is more about what is the art of the possible? What can we do with this database? What is out there? What is new? What else is Microsoft working on?

I have not seen any negative aspects regarding the latency and availability of Azure Database for PostgreSQL. I have not heard anything. It is keeping its SLA. There have been other challenges at least a few weeks ago on the Microsoft front. However, Microsoft's ability to turn things around relatively quickly and being very transparent to its customers on shortcomings is positive. I think we are in a stage now where we do not worry about resiliency and disaster in the cloud as much. Some business stakeholders are thinking about it here and there, but overall we know that once in a while we are not expecting it to happen a lot but once in a while things may go south in the cloud. We trust and believe that Microsoft has the capability to quickly rebound.

I have not had any chance to have experience with the customer service and technical support of Azure Database for PostgreSQL. That is not really because of a particular reason; my team is pretty good at navigating the Microsoft product system and the technical nuances of Microsoft.

The security features of Azure Database for PostgreSQL are good out of the box. I do not know if to say if it is good compared to what, as it is a native product. It is a great product in terms of out-of-the-box security. I have not heard any issues. We have not seen any hacks or any compromise to the product over many years. Overall, security is just out of the box and not so much a concern; it is more so how best you integrate it with applications knowing that it is feature-rich from a performance perspective and how it reacts to applications. Security is not really a challenge from what I know from feedback from developers.

It is a bigger conversation regarding changes in time to market for applications or customer applications. The database is definitely one of the factors, but it is holistic. It is the application itself, its logic layer, it is the company's strategy around the data, the application and user experience. I would not say this is just a singular element. It is hard to say or answer that question.

Azure Database for PostgreSQL has facilitated the adoption of AI technologies in my company's database operations. That is an evolution. For the client base that I serve, they are not quite there yet where Azure Database for PostgreSQL is specifically called out. They are mostly in the early adopter stage when it comes to AI and it is mostly a focus on data readiness, understanding data governance and data structure.

Azure Database for PostgreSQL impacts the ability to innovate or stay competitive in an industry. The art of the possible of the tool, the AI features would definitely be a plus for organizations moving to AI, enabling competitive advantage. I would say it is not even competitive advantage only. It is performance to get speed to market eventually. AI is almost the foundation to any success going forward. It is not just the buzzword. I see it as the heartbeat to the future. Anything that is AI capable or AI embedded would definitely be a step forward to success.

Azure Database for PostgreSQL has not helped reduce infrastructure costs for me or my clients. The database has not reduced infrastructure cost; databases are costly in general. What we appreciate in the industry is some right sizing of the cost or some consideration around cost. But in general, it is a cost element. There are other aspects of the holistic solution where opportunities to reduce cost can be found, but anyone in the industry would say that going down that path will require spending money on database. What we appreciate is that it has been offered as lean and considerate as possible from Microsoft.

Regarding the pay-as-you-go pricing model of Azure Database for PostgreSQL, it depends. If there is an opportunity to lock in pay-as-you-go versus reservation, it depends on your business model. At the end of the day, it depends on the business outcomes you are seeking for the application or the database. You have to forecast where you will be tomorrow, next week, next year, and lock in accordingly. Pay-as-you-go would work for various use cases. If you just need the application for two months, pay-as-you-go is fine. If you need to be locked in for a few years and it seems right-sized for exactly what you need, reservation is the way to go. It probably seems like a conflicting answer and conflicting question because again, it is part of a holistic solution. The database is just one; it cannot stand alone. The database is nothing by itself but it is definitely important. The answer is it depends on the use case.

I do use Azure Hybrid Benefit, and I think my clients have seen benefits when they access this feature. The ones that are already consuming licenses from the legacy strategy, they see a lot of benefits in leveraging the program. That is also serving as an encouragement to move to Azure from on-premises or in a hybrid situation. Overall, it has been positive for clients. It is something that service providers have to educate clients on. It is there but it is up to us to bring that knowledge and the benefits to the client. Azure Hybrid Benefit is out there and something that clients should make use of, but I think the education level on the client side is not there yet. It is really up to providers, not just hybrid benefit, but incentives in general. The more we are educated about incentive programs, the better it will be for us articulating to clients and also better to bring clients to the cloud or encourage clients to venture elsewhere. If they have moved to the cloud just in pockets, maybe just a fraction, but knowing about these benefits, especially migration benefits or consumption benefits, it will accelerate innovation or move to Microsoft.

Regarding uptime, Azure Database for PostgreSQL has been able to change the uptime of the application. It depends on application architecture and how the overall architecture is designed or the application is designed. That is a loaded question because the database is a standalone component of a holistic application. The database could be all resilient but other aspects of the application could fail. It is not fair to blame the database for the application's uptime.

My advice to other companies that are considering Azure Database for PostgreSQL is that it is one product that comes as a result of a bigger conversation from a strategic business alignment perspective, application architecture and application requirements. It should be highly considered. It is scalable, high performance, and resilient. We have not seen any issues over the years. It is matured and has worked out all the kinks that it used to have years ago. If a client is looking to check these boxes—performance, speed, reliability, and resiliency in general—knowing that it will satisfy application needs not just today but in the future, it is definitely a choice. I would rate this product a 9 out of 10.

Our main use cases for Azure Database for PostgreSQL include security dates, security tools, and a couple of small applications that move data and read data from other sources such as logs or claims and process it. Some of our use cases are simple websites that use Azure Database for PostgreSQL.

We are starting with Copilot and agents built from Copilot. It will almost be the year of our agent for next year because many people are asking for Copilot Studio. On the keynote, we saw the old App Maker or App Builder. I am always looking at how people can make small things and be out the door already using the Azure Copilot environment. We are looking forward to that.

we are working to a proof of concept. so we are totally ready to see what can be improved.

The most valuable features of Azure Database for PostgreSQL for us are reliability, performance, and cost, making it a good cost-benefit for us.

For Azure cost-benefit, not having an on-premises solution and having Azure Database for PostgreSQL on Azure means we leverage Azure Database for PostgreSQL being built and maintained by Microsoft engineers who know far more than I do. They already have the experience to ensure that the application is up and running and any recommendations that come from it. For example, they provide recommendations such as 'you should probably run it like this' or 'you are missing some optimizations.' That is the kind of information I would like to see.

Patching is seamless. The applications we have running there, SharePoint, and all the other services, those get patched and we never get any downtime. Having databases up and running all the time would be great because it is a struggle now.

We would love to definitely see scalability. We would love to see it grow as more people use it and it can handle the data and maybe tell us some optimizations by reporting on what we have. Hopefully, we will see more security features. We can ensure that we are doing good governance on that and that the data that should be there is there and we are controlling access to it.

I have been in my current role for about five years.

Azure Database for PostgreSQL is very stable. Many companies have blips when their internet goes down and things happen. All cloud platforms experience downtime, but it has been very available for us.

It is something we can spin up and test and start running for applications on a small level. Once you can prove that, we can go big. We do not have to buy everything and build it. It is already there. We just throw on a switch, and it is ready to go. We can use that much. Later on when people say they like it, we can say great and really ramp up using it.

We have not expanded usage at this time.

I have used Microsoft Support, but not for Azure Database for PostgreSQL. I have used it for other services.

I would rate it an eight because sometimes I get someone who knows their material and they solve the problem quickly. Sometimes I have to jump through hoops of doing many things and then the person says they cannot solve it. That is when I realize they are just reading from a script. When I am in a time crunch, you want to get to an engineer level problem quickly. Sometimes it takes too long for me to get to an engineer level problem that I want, but sometimes I get there and find a person who has the solution. I think that is great.

Positive

We looked at Snowflake. We were looking at other options. We have a little bit of MySQL, but that is not really cutting it anymore. There is Azure Database for PostgreSQL running on another cloud vendor as well.

The setup is fairly point-and-click. We just look at the steps to grow it. All the other decisions on the other side are on Microsoft's side. When we want something this big, Microsoft makes it happen. I do not have to think about how much memory I need or how much RAM I need. I do not have to think about whether the server is going to be big enough or what we have to build or whether we have to build a cluster now. We do not have to do that anymore.

At this point, that is not applicable. Someone else sets it up. My manager and the vendors set that all up.

For us, the build was fine. It is mainly repointing information. We are kind of interconnected, so you have to find a database that is not something we move and that is pretty standalone. It is mainly figuring out what our own business is and what is pointing at it more than anything else. Once you figure that out, you can change the connectors and everything else. That is more from the application side and our UC4 and any automatic processes that we have running or SQL processes.

I would say the ROI is a nine because we are just starting to want to get it up there and it has been easy for us to build up and do a small thing. We have not stressed it out yet. We are trying to get to the proof where we are talking to one group and saying let us move something else over there now. That takes time. We are not quite there yet where we are really stressing something out.

advise to get E5 for better security and governance of your data and systems

I do use Azure Active Directory integration for security. Using Azure helps us say you only get a certain amount of access based on whether you are a corporate device or your own device. We are already using features like that to help secure and keep our data safe.

We are starting with Copilot and agents built from Copilot. It will almost be the year of our agent for next year because many people are asking for Copilot Studio. On the keynote, we saw the old App Maker or App Builder. I am always looking at how people can make small things and be out the door already using the Azure Copilot environment. We are looking forward to that.

I do not think we are there yet to really get that benefit. I do not think I am there yet either. Our overall review rating for Azure Database for PostgreSQL is nine.

Hybrid Cloud

Microsoft Azure

Azure Database for PostgreSQL serves several use cases for me. I use it primarily for testing and development environments where I need flexible database access without long-term commitments.

The pay-as-you-go pricing model is one feature I truly appreciate. I can pay for only the amount of time I need the database, which is very efficient for my test environment and development work. I don't have to purchase upfront to gain access; instead, I just get billed for the specific hours I use the database. This makes me more inclined to develop when I know what I'm expecting. However, when I start planning for production where the service will be up for two or three years, I prefer to pay upfront, as the pay-as-you-go model becomes expensive for production use.

Another significant benefit is that I don't have to worry about power management and security concerns associated with physical servers. With a physical server, many people could potentially gain access, which makes tracking difficult. Azure Database for PostgreSQL allows me to create different user accounts with specific access levels, which greatly helps my monitoring process, logging, and incident response. I can monitor when my database is accessed by unauthorized users and receive alerts for those events.

Apart from the scaling aspect, I would like to see improvements in the user interface. If a guided journey could be created, I would prefer that approach. Some cloud platforms I've used have journeys that guide you through processes, but with Azure Database for PostgreSQL, I have to know exactly what I want to do and navigate there myself. This was not beginner-friendly for me at the beginning.

I have been using Azure Database for PostgreSQL for four years.

Regarding availability and latency, I learned that placing all my services in one networking environment reduces latency significantly. I put them in different availability zones to ensure reduced latency of communication between virtual machines and all my services alongside the database. Once everything is in the same networking environment, the latency becomes much smaller compared to when I have everything spread across different availability zones and regions, which results in higher latency.

Azure Database for PostgreSQL demonstrates strong scalability capabilities for my workloads.

Microsoft technical support replies very quickly. I have had two issues, and when I raised support tickets, I received responses within two to three hours and they were able to resolve both issues. My first issue concerned my billing account where my credit card was not being accepted. I reached out to support about a credit card that had been working previously, and they resolved it for me. My second issue was concerning session hijacking. I was trying to figure out the best approach to protect my company against session hijacking, where people's session tokens get stolen and reused by attackers. Support advised me to use the feature of making sessions expire after 24 hours, which means users have to log in again after that period. This was accomplished using Entra ID. If a session gets hijacked, attackers would be logged off after 24 hours. The support team was very helpful in resolving this.

Before Azure Database for PostgreSQL, I used on-premises solutions. When I was working as an intern, most of our servers were Microsoft servers housed in-house. In terms of power consumption and power accessibility, the shift to Azure has been beneficial. Having to power the Microsoft servers we had at that time was quite burdensome on the organization I worked with then. We had to use inverters and other backup solutions because we were in Nigeria where power issues are common. Everything related to power was expensive, but with Azure Database for PostgreSQL, we were able to run operations easily because all of those infrastructure costs were offset.

I rate Azure Database for PostgreSQL a nine out of ten.

Hybrid Cloud

Microsoft Azure

My main use cases for Azure Database for PostgreSQL are Edge, Edge AI, and edge data consolidation.

What I appreciate most about Azure Database for PostgreSQL is not one particular feature; I think it is the use case and the facility to have a single pane of glass for managing what is on the edge, what is on the cloud, especially now with Azure Local as well. It is not a product per se; it is the ecosystem integration overall.

The ecosystem integration of Azure Database for PostgreSQL benefits my company by having fewer moving parts, fewer points to break and touch. It simplifies operations and provides a seamless interface.

Microsoft needs to start developing specific agents that would be focused on Azure Database for PostgreSQL. It is almost like in the database world where stored procedures exist. Creating similar stored procedures but for agents within the database would be beneficial. This is not easy to implement as it requires architectural changes, but this would be a game changer for everybody.

I have been using Azure Database for PostgreSQL for approximately ten years.

I would not know if my company's database uptime has changed after implementing Azure Database for PostgreSQL because I am not tracking that. A team tracks that, and I have not heard any complaints, which I think is a good sign.

My impressions regarding the latency and availability of Azure Database for PostgreSQL are positive. Overall latency, especially for edge deployment, needs to be very short and very low, and that is what we are getting.

My impressions of Azure Database for PostgreSQL's ability to scale workloads are within what I expected. However, it is scalable up to a certain size and volume. Some of the use cases that I have on edge are simply not possible to do with PostgreSQL given performance requirements, which is why we are exploring other options with Microsoft.

I would rate customer service and technical support at Microsoft an eight out of ten. They have good technical support with no complaints.

Positive

Regarding my experience with the migration process to Azure Database for PostgreSQL, we did not use Microsoft support. We had the skill set in-house, so the migration was relatively simple to execute. We performed it at an application data layer rather than at a DBA level.

Azure Database for PostgreSQL has not helped reduce infrastructure costs.

The pay-as-you-go pricing model of Azure Database for PostgreSQL has actually increased costs. The licensing model that I had before in some use cases was very beneficial and included volume discounts. Once you move to that model, if you do not have it tightly integrated with FinOps, you will pay more.

In comparison to my previous expenses for maintaining an on-premises PostgreSQL database, the costs are higher.

Azure Database for PostgreSQL has not influenced my application development process.

Azure Database for PostgreSQL has not moved the needle in terms of my ability to innovate or stay competitive in my industry.

The integration of Azure Database for PostgreSQL with other Azure services has not impacted my overall cloud strategy.

We continue to share with different clients a positive view of Azure Database for PostgreSQL, and there are use cases for it, but it is not universal. There are other options available. We do have several pilots going on, especially for edge deployment. I would rate this review a nine out of ten.

Public Cloud

Microsoft Azure

My main use cases for Azure Database for PostgreSQL came from a personal project to scratch an itch, and it was the easiest one to go grab.

I appreciate how easy PostgreSQL is to get running locally. You can grab a container and run it, as opposed to the old days when having a local database was very challenging and required special scripts that would take hours to run. Now I can grab a container and be good to go in seconds, which makes life a lot simpler and has influenced my application development process.

My experience with the monitoring and management tools provided by Azure Database for PostgreSQL has been minimal, but the ability to see what's there and tweak it is a good feature to have.

Azure Database for PostgreSQL security features such as encryption and advanced threat protection are very helpful, especially when you have medical data and personally identifiable information that you need to protect. The fact that these security features are embedded certainly makes my job easier. The ability to encrypt personally identifiable information and health data at rest is what my company finds most valuable.

Azure Database for PostgreSQL integration with other Azure services has impacted my overall cloud strategy. Depending on the customer, having it there and having it be easy to utilize, with the ability to switch to it, is valuable. I have conversations where customers are using one data store, but maybe that's not the right data store and perhaps another should be used instead. The fact that you can do this with such a low barrier of entry makes it simpler to have those conversations. It isn't a situation where you have to hire somebody who knows how to stand this up; you just click and now you have that data store.

Azure Database for PostgreSQL integrations have been most beneficial to my operations with Azure Kubernetes Service and Container Apps. The different eventing systems provide another valuable conversation point about which of the three different eventing systems should be used. The different tiers available allow you to think in terms of crawl, walk, run. You don't have to go straight to the heaviest duty enterprise level until you need it. When you're just getting started and trying to find market fit, you can use something simpler that gets you up and running with some training wheels and fewer knobs you need to worry about. When demand requires it, you can graduate to the next tier up.

Azure Database for PostgreSQL has helped reduce infrastructure costs depending on the client.

Azure Database for PostgreSQL can be improved in ways I'm very curious to explore with Horizon. I'm interested in seeing how the fully enterprise-hardened features change things and where that blurs the lines with other data stores available on Azure, as that will probably make it harder to choose between solutions.

I've been working in my area of expertise for almost thirty years.

Compared to my previous expenses for maintaining an on-premise PostgreSQL database, Azure Database for PostgreSQL is far easier, far simpler, and far cheaper in my opinion. Having to maintain staff whose job is the care and feeding of the database and the time it takes to get a local version spun up for somebody was a burden. Being able to do that with some clicks is a huge win. Additionally, you don't have to worry about whether it's up to date, because it always is.

I have previously used an on-premise database.

Azure Database for PostgreSQL has influenced the adoption of artificial intelligence technologies in my company. Artificial intelligence is definitely in almost every conversation that happens these days. The clients I've worked with haven't used it yet, but it's at least in the air. That's another thing that will eventually have to tie in, depending on the customer.

Azure Database for PostgreSQL has had a significant impact on my company's data protection strategy compared to previous solutions. Not having to manage it yourself is a huge win. You can shift that responsibility to someone else who does it at scale and can hire the best people in the world to do it. It's one less thing that you need to spend cycles on, so it's just an overall win.

My experience with the migration process to Azure Database for PostgreSQL, particularly in terms of the technical expertise required and support received from Microsoft, is generally straightforward as I've seen it. It helps to have people who've done it before and know the pitfalls and can help you speed things up, but by and large, it's a fairly straightforward proposition. How much data you have does matter for the timeline.

I would rate Azure Database for PostgreSQL overall a nine out of ten, and we will see how the Horizon offering works.

My advice to other companies considering Azure Database for PostgreSQL is to choose the data store that makes sense for your use case. I've noticed a tendency to just grab whatever database was used last time, but maybe that's the right choice and maybe it's not. I've seen instances where people choose a data store because they think it's cool or they want to play with it and put it on their resume. Resume-driven design is a real thing. Make sure the data store you choose is the right one for your use case. If you're doing microservices, you don't have to have one-size-fits-all. If a service needs a time series database, then use that. If a service would benefit from graphs, then use graphs. Use the data store that fits your needs.

Public Cloud

Microsoft Azure

My main use case for Azure Database for PostgreSQL is managing MIS data and dashboard creation for the organization. I use Azure Database for PostgreSQL to create dashboards, generate MIS, and prepare and share MIS for resources.

I have been using Azure Database for PostgreSQL for the past two years, and I have not encountered any issues with it; it is smooth and time-saving.

The best features that Azure Database for PostgreSQL offers include generating reports with low time consumption and being time-saving. When I say it is time-saving for generating reports, it speeds up my work because pulling data from Power BI and collecting data through Microsoft Office and advanced Microsoft tools is very easy, and Azure Database for PostgreSQL delivers reports quickly.

Regarding the features of Azure Database for PostgreSQL, the reliability is very good and integrity is also good for using current database services.

Azure Database for PostgreSQL has positively impacted my organization through collaboration. It has helped with collaboration by allowing me to send the MIS database, such as generating a report within a second and sending the MIS for an employee or a team, making it very easy to display for business purposes.

I have noticed faster decision-making since using Azure Database for PostgreSQL, as it provides a faster decision-making process.

All features of Azure Database for PostgreSQL are good. No improvements are needed, as everything is good and the business is running fast.

I have been using Azure Database for PostgreSQL for the past two years.

Azure Database for PostgreSQL has not influenced my ability to innovate or stay competitive in my industry, as everything is good and the business is running. There has been no change in my organization's database uptime after implementing Azure Database for PostgreSQL.

Azure Database for PostgreSQL is deployed in my organization as on-premises and hybrid cloud.

My experience with the monitoring and management tools provided by Azure Database for PostgreSQL is good.

My experience with the migration process to Azure Database for PostgreSQL has been good; whenever I required assistance, the Microsoft team helped me quickly.

This migration to Azure Database for PostgreSQL has been good with no issues reported.

Compared to my previous on-premises database, Azure Database for PostgreSQL is good, and PostgreSQL is better compared to other platforms.

Azure Database for PostgreSQL is deployed in my organization as on-premises and hybrid cloud.

We use AWS as our cloud provider for our hybrid deployment.

We purchased Azure Database for PostgreSQL from the AWS Marketplace.

The pay-as-you-go pricing model of Azure Database for PostgreSQL has not negatively impacted my database-related costs and resource allocation; it is good and there is no issue with that.

Azure Database for PostgreSQL has not influenced my application development process currently; if it is required, I will definitely collaborate with them.

I have not noticed any changes in time-to-market for my applications since using Azure Database for PostgreSQL.

I rate Azure Database for PostgreSQL a ten out of ten.

I give it a ten out of ten because Azure Database for PostgreSQL is providing a response quickly and generating reports faster, with good reliability and very low time consumption.

I think the governance and security of Azure Database for PostgreSQL's AI capabilities are good; I cannot send data outside of the organization, and Microsoft is very strict.

The accuracy and reliability of output from Azure Database for PostgreSQL are good.

The integrations that have been most beneficial to my operations include Power BI and Microsoft Office.

My impressions of Azure Database for PostgreSQL's security features, such as encryption and advanced threat protection, are that Microsoft security is the only feature I find most valuable.

Azure Database for PostgreSQL has facilitated the adoption of AI technologies in my organization's database operations; it is good and everything is perfect for the current organization and database.

Azure Database for PostgreSQL's integration with other Azure services has impacted my overall cloud strategy for generating MIS reports, creating dashboards, pulling data from Power BI, and arranging data through advanced Microsoft tools; it is good.

Azure Database for PostgreSQL is deployed in my organization as on-premises and hybrid cloud.

I would rate Azure Database for PostgreSQL a ten out of ten.

Hybrid Cloud

Amazon Web Services (AWS)

My main use cases for Azure Database for PostgreSQL are to use it as data storage for a lot of apps, involving different app services, functions, and other platforms, where we bring in and process a lot of data for integrating different cloud platforms. We have document management systems where we're pulling back-end data from on-premises systems or other cloud systems, using many Azure functions and different app services to pull data through Azure Database for PostgreSQL to track and sync with other systems.

Azure Database for PostgreSQL has influenced my application development process by enabling me to take some of what we used to do on-premises, with PostgreSQL hosted in virtual machines, and transition that process into a SaaS solution. This transition means we don't have to spin up a virtual machine for installation and configuration, streamlining the process and making it faster and allowing us to script much of it out, so whenever our developers need a new environment, it's just a couple of clicks and an automation, resulting in a consistent build every time.

The impact of moving to Azure has been significant; we can take what was already built on-premises and split it into services without needing to build a whole server, making the deployment much lighter, faster, and scalable.

My favorite feature about Azure Database for PostgreSQL is that it's quick and easy to set up and deploy, without a lot of overhead or configurations, making it fast and easy to include in any of our builds. When we automate for scaling up or scaling out, it's easy to do that automation side of it, and since it's PostgreSQL, it's lightweight and simple for the basic things we need to do from a data perspective, so it works well.

A benefit that Azure Database for PostgreSQL has for my company is that it serves as a native back-end solution for several utilities and tools that we use, making it a quick and easy solution that we deploy as part of larger problems or solutions. This capability helps us scale economically because we're often reselling these solutions, keeping our costs down and making deployment and rollout easier.

My impression of the security features in Azure Database for PostgreSQL, such as encryption and Advanced Threat Protection, is that it has met all of our security requirements; anytime our apps go through a security review, we've never had any issues while using identities and registering the app. It has been great, trusted, and it works without needing extra security reviews for implementation.

Regarding improvement in Azure Database for PostgreSQL, I would have to discuss that specifically with our lead developers.

I have been using Azure Database for PostgreSQL for approximately seven or eight years.

I can assess the stability and reliability of Azure Database for PostgreSQL as excellent; we have no issues or problems with it. Occasionally, we experience throughput issues due to bandwidth limitations of client setups with Azure, which have limited connections, but as far as the service itself goes, it has been rock solid.

In some ways, Azure Database for PostgreSQL has facilitated adopting AI technologies in my organization, mainly because we can take output from AI processes, particularly document and contract summarization, and dump that data into a database for later retrieval. We are only beginning to experiment with this and hope for more native solutions within the AI tools, which are now coming, and PostgreSQL has allowed us to lay the groundwork for this. I rate this product a 10.

Public Cloud

Microsoft Azure

We are an insurance company with many applications that handle policy processing, so we use Azure Database for PostgreSQL for those applications. We have different usage for every database, and for all of our in-house applications, we use Azure Database for PostgreSQL.

We have monitoring for Azure Database for PostgreSQL. Our on-premises monitoring is connected to LogicMonitor, which we use as a centralized monitoring tool. If a database has any task that has been interrupted or any connection issue, it will alert LogicMonitor, and we have a centralized panel for all the alerts.

Regarding Azure Database for PostgreSQL security, I have not received any report or incident indicating a breach to our database. However, I cannot definitively say this is because of Azure Database for PostgreSQL or our overall security ecosystem.

I am not certain if Azure Database for PostgreSQL helped reduce infrastructure costs because we are in the process of migrating to the cloud. Our on-premises cost and on-premises infrastructure cost is fixed, and we pay an annual fee to the data center. Once we migrate to Azure, I could check the cost bill, but I have not yet. This is not my main responsibility. The management definitely did an estimate, and I think it will probably save some money for them, which is why they chose to migrate. That is my assumption.

I am not a DBA, so for my experience with Azure Database for PostgreSQL on the database side, I do not know if it has certain capabilities. The most significant thing I do and communicate with our DBA about is performance tweaking. I think we still have to do it regardless because you still build on a server with the OS level on it. I do not know if in the future the database will have its native OS layer instead of using Microsoft and dynamically assign the CPUs and memories based on the transaction or task it is running. This could save us some time so it does not have to use sysadmin's time to constantly tweak and assign the CPU. Currently, most databases will try to use all the CPUs available and use all the memories available. We try to give all the databases one hundred percent of the hardware capacity, but sometimes because the OS layer itself will need some resources. If the database used everything, when we try to remote to it, sometimes you will just see a black screen. If we can make this better, why not?

On the deployment side of Azure Database for PostgreSQL, it is easy to deploy. The deployment of Azure Database for PostgreSQL is pretty straightforward, and there is not much to specify. It is very basic. Usually I will work with the DB team, they will give us all the instance, all the SSA, and all the accounts. We basically deploy, install it, and deploy it.

The deployment of Azure Database for PostgreSQL usually takes one hour for us to deploy it. I do not know if the deployment time for Azure Database for PostgreSQL is similar to other solutions. For MS SQL, I think it is also the same amount of time. For AWS, I cannot say because it is a cloud team thing, and I deploy on-premises.

I am the admin part, so I basically deploy Azure Database for PostgreSQL. I do not actually directly use the product, but I do the deployment.

I cannot say much about the features of Azure Database for PostgreSQL because I am not the actual user and just do the deployment.

Azure Database for PostgreSQL has influenced our application development process, which is the reason why we stick with Azure Database for PostgreSQL. Otherwise, we would not use it as heavily. Our company's strategy is always to not put all eggs in one basket. We have Azure Database for PostgreSQL, MS SQL as well, and some AWS databases. We have all kinds of DB and also MongoDB.

For our solution using Azure Database for PostgreSQL, I have never gotten any complaints from any incidents, security incidents, or any technical troubles. It is very rare, but incidents are code-based and not database-related. We have some code-based incidents because the application has some bugs, so we have to fix them. Based on the database itself, the most tweaking we did was the performance. We have to monitor the performance of all the transactions and all the journals, and we have to do tweaking such as determining how many CPUs and memory we have to reassign to those servers and applications. That is the only thing that we actually deal with. The patches happen on the Windows server side because we use Microsoft servers. Most of the patches happen on the Windows server side, though we have Linux servers too. When Microsoft releases some patches, it will sometimes interrupt some connections, but it is not a PostgreSQL issue and is just a server issue.

We are a hybrid environment including our on-premises AD. We are in the process to migrate and try to get rid of our on-premises AD and completely use Entra as our main identity management solutions. Currently, we are hybrid and everything is Microsoft. We also use Okta as well. We have Okta and Entra. The hybrid arrangement has its advantage because it really connects our old legacy technology. Everything has to be on-premises because we have not had time to completely convert it to cloud apps yet. The hybrid approach creates a bridge to both worlds. A native cloud approach actually has more advantage because it is easy to deploy, faster to deploy, and easy to recover and roll back. It is more agile and more convenient for us. It really shortens the time for us to deploy on-premises. When you try to deploy something on-premises, especially when a new product comes in, you have to get the hardware, set up all the firewall rules on-premises, and then deploy all the applications on those servers. Because we moved to AWS and moved to Azure, everything is basically just policies, and you can define everything in the cloud. It is way faster and more convenient for us. I gave Azure Database for PostgreSQL a rating of nine.

Hybrid Cloud

Microsoft Azure

We have a few custom-built applications where we use Azure Database for PostgreSQL as the database layer. It is not used for Azure Database for PostgreSQL because it's for an online service.

Horizontal scaling has helped manage our workloads, making it easier for us to stay cost-efficient while also scaling when we get more traffic on our application. Our applications often don't get as much traffic, so we can scale down in terms of cost efficiency by utilizing Azure Database for PostgreSQL. If there is a reason why the traffic goes up, it scales up without our hands on the service.

Azure Database for PostgreSQL is fully managed, so I don't have to manage it on my own. That's the main thing from my point of view.

When it comes to network integration, we always try to have everything in a private network. There were different options on how you can deploy it, and it was a bit difficult to understand what the right option was for us.

It's not so easy to replicate it to another region or something of that nature. At least, the last time I had my hands on it was one or two years ago, so perhaps things have changed.

I have been using Azure Database for PostgreSQL for three or four years.

We have not had any outages that I'm aware of with Azure Database for PostgreSQL, so it's working well.

Azure Database for PostgreSQL is not our main database, so it's working well for the purpose of scaling with the growing needs of our company.

Microsoft support for Azure Database for PostgreSQL rates about four out of ten based on my experience. You always get the same questions with Microsoft support, and it's not really straightforward. We already pay for better support. It was worse before, but now it's still worse, not as bad as before. It really depends on which team or which person takes over the case. We have a few good experiences, but the majority is not so good.

Neutral

For the service I had in mind, I did not use another database prior to adopting Azure Database for PostgreSQL. This custom-developed application was developed by an external company for us, and the technology and database were already chosen.

The experience with pricing, setup costs, and licensing of Azure Database for PostgreSQL was straightforward from my point of view. There is some marketplace licensing involved.

I have been involved in deploying and implementing Azure Database for PostgreSQL. We deployed the whole project through Terraform, and it worked for Azure Database for PostgreSQL with no issues.

To be honest, I don't know how much money we're saving by horizontally scaling up and down in terms of return on investment in Azure Database for PostgreSQL. I think it's mainly operational cost that we save.

I personally did not consider any other database for this project.

That's something I would need to ask our developers regarding how Azure's integration with other services has impacted our application development. I have not realized other benefits from using Azure Database for PostgreSQL. This review received a rating of 8 out of 10.

Private Cloud

Microsoft Azure

As a Cloud Service Provider, I manage a significant portion of Azure Database for PostgreSQL deployments on behalf of my clients. I handle provisioning and configuring monitoring for these instances, so my experience is primarily from the platform aspect rather than the data level. I can share insights regarding monitoring, relevance, and metrics.

For the clients I manage, there is seamless integration between Azure App Services and Azure Database for PostgreSQL, which provides me with valuable experience in this area.

I appreciate the rich metrics provided by Azure Database for PostgreSQL, especially the availability metrics that enable me to receive notifications and manage expectations if anything goes down. This ties directly into disaster recovery solutions, allowing for faster failover to secondary options when needed.

My experience with the monitoring and management tools provided by Azure Database for PostgreSQL has been positive. The logs from the host level to the database itself are very relevant and provide the correct metrics I need, including availability metrics that help me receive notifications when databases are down from the platform perspective.

Regarding security, I find the integration with Defender for Cloud valuable as it offers recommendations on how to harden databases. Features such as private endpoints that restrict access and the role-based access control capability allow me to provide necessary access to people who need to view databases on the portal.

I have not been involved in development, so I cannot share much on improvements or enhancements I would like to see at the moment. I am comfortable with the graphical user interface of Azure Database for PostgreSQL, and the Azure calculator is useful for obtaining pricing information. I cannot mention any improvements at this time.

I have been working with Azure Database for PostgreSQL for approximately one year.

Overall, I find Azure Database for PostgreSQL to be predictable and reliable, as I have not encountered any performance issues with it.

Azure Database for PostgreSQL has proven to be stable regarding scalability. I have not had clients whose workloads need to exceed current capacity, and it appears we are right-sizing well. I have not performed load testing to determine what happens with high CPU, RAM, or storage usage.

I rate the technical support from the Microsoft tech support team as a seven out of ten. I have been in very few situations where I needed to escalate with Microsoft support, as most issues are well covered in the documentation.

I rate it a seven because it sometimes takes a while to receive that first response from them, which may depend on the case. If they could improve response time, especially for critical scenarios, it would be beneficial. The aspect of being charged for technical calls as a Cloud Service Provider also discourages engagement, causing me to seek solutions through the community or internally.

I have not worked with on-premises PostgreSQL databases prior to adopting Azure Database for PostgreSQL.

Since implementing Azure Database for PostgreSQL, I have not seen a client migrate from one instance to another, so I cannot specifically tell you whether there have been any changes in application uptime, but I believe there must be.

I have not utilized Azure Hybrid Benefit with Azure Database for PostgreSQL, but I have used it for SQL and on virtual machines.

Azure Database for PostgreSQL has helped reduce infrastructure costs for my clients, as they pay for what they use and can improve or increase storage whenever needed without having to over-provision resources.

Regarding the pay-as-you-go pricing model of Azure Database for PostgreSQL, for the clients I manage, I utilize reservations for databases, so I have not seen cost issues due to this aspect of cost optimization.

Overall, based on my experience with Azure Database for PostgreSQL, I would rate it a nine out of ten, as I have not faced many challenges with it. The reason for not rating it a perfect ten is that I believe technology requires upgrades and there is always room for improvement. While I have not pictured a certain integration, I think developers could provide better insights if they were more involved.

I do not have the ability to comment on whether Azure Database for PostgreSQL has influenced my application development processes, as I am not in a position related to the development team.

I cannot provide a specific answer on how integrations of Azure Database for PostgreSQL with other Azure services have impacted my overall cloud strategy, as I am not at the decision-making level in my organization. My focus is mainly on delivery.

From my experience with Azure Database for PostgreSQL, I cannot share specific integrations that I find most beneficial, as I have not interacted with it extensively. I believe that would be better feedback from a developer actively developing applications.

My advice for organizations considering Azure Database for PostgreSQL is to embrace observability and monitoring, as I have seen many customers neglect to enable monitoring or log collection. These tools are essential for diagnostic settings and help in observing, managing, and receiving alerts for any issues. I would rate this product a nine out of ten based on my overall experience.

Public Cloud

Microsoft Azure