PostgreSQL Like a Pro: Performance and resilience with Azure Database for PostgreSQL
Microsoft Developer features Gauri Kasar explaining how Azure Database for PostgreSQL supports resilient, high-performance app deployments, including high availability, read replicas, backup/restore, and elastic clusters for scaling.
PostgreSQL Like a Pro: Performance and resilience with PostgreSQL on Azure
Gauri Kasar (Microsoft Developer) walks through how Azure Database for PostgreSQL can be deployed and operated for performance under pressure—with a focus on resilience features, read scaling, and recovery.
What the video covers
- How PostgreSQL on Azure is positioned for performance and resilience
- A demo of common deployment and operations tasks
- Scaling patterns (including horizontal scale via elastic clusters)
- How Azure supports failover, recovery, and scaling to keep apps online
- Notes on AMD-powered SKUs for price/performance considerations
Demo walkthrough (as outlined in the video)
- 0:00 – Introduction
- 0:20 – PostgreSQL on Azure delivers performance and resilience
- 1:17 – Demo: deploy a server
- 1:54 – High availability configurations
- Deployment options for improving uptime
- 3:09 – Boost read performance
- Using read replicas to scale read workloads
- 3:50 – Backup and restore
- Recovery options via backup/restore workflows
- 4:04 – Create an elastic cluster
- 4:40 – Scale out with elastic clusters
- Horizontal scaling approach
- 5:19 – Demo recap
- 5:29 – Intro to Azure HorizonDB
- 5:48 – Wrap up
Links
- Watch the series: https://www.aka.ms/PostgreLikeAPro
- Get started: https://www.aka.ms/Postgres-performance