What is our primary use case?
We started using
Azure Database for PostgreSQL about five to six years ago. Initially, we were doing an on-premises
Kubernetes setup, but since
Azure was accepted at the bank, we moved to
Azure. We currently run fairly large clusters with around five clusters spanning three environments, along with disaster recovery aspects and smaller clusters for specific products.
What is most valuable?
Having a relational database like
PostgreSQL, which is cheaper than competitors, is beneficial. We have extensive experience with
SQL Server and Sybase
SQL Server, but the applications mainly care about the backend database's total cost. As long as it meets the needs, it serves its purpose well.
What needs improvement?
While the flexibility of the server for financial reasons is understandable, better switching between primary and backup would make transitions smoother. I noticed an issue where the primary refuses to launch if the backup isn't running. Another improvement could be the ability to scale storage back down after scaling up, as we can do with compute resources. It's likely a financial restriction from Microsoft.
For how long have I used the solution?
We started using
Azure Database for PostgreSQL about five to six years ago.
What do I think about the stability of the solution?
When not abused and sized correctly, performance has been very good. We are holding large volumes of data, and it has been doing well for us.
What do I think about the scalability of the solution?
We can scale up compute and scale it down, but once storage is allocated, there is no way to scale it back down.
How are customer service and support?
Given the amount of money we spend with Microsoft, we receive excellent support. As a big bank, we get prompt responses, especially for high-severity issues. Once we open a support case, we have people engaged within about 20 minutes, especially for a Sev 1 issue.
How would you rate customer service and support?
Which solution did I use previously and why did I switch?
I have a lot of experience with SQL Server from a previous position and even more with Sybase SQL Server from a previous role.
How was the initial setup?
We abstracted the normal Azure creation mechanisms using a PowerShell-based system. I create a JSON config with the server details, and it quickly creates them. Initially, running the templates required frequent updates as configurations drifted in a young system. Now, it's managed behind the scenes, and I don't experience the pain.
What about the implementation team?
It doesn't take much to maintain. We have a couple of individuals managing it alongside their other responsibilities. It operates like an internal open source project, where anyone can contribute. If an issue arises, I communicate it to them, and they address it.
What other advice do I have?
Overall, Azure Database for PostgreSQL has been good for us. When sized properly, performance has been great, and we handle substantial data volumes. I would rate it an eight or nine.
Which deployment model are you using for this solution?
Hybrid Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.