Cons
· Scalability limitations: While PostgreSQL can scale vertically, horizontal scaling for large-scale deployments may require additional complexity and effort.
· Performance: For workloads with high concurrency or throughput requirements, PostgreSQL may require careful optimisation to maintain performance.
· Cost: While PostgreSQL itself is open-source, managed PostgreSQL services on Azure may incur costs based on usage and configuration.