About this episode
See how a single Azure Database for PostgreSQL Flexible Server scales read-heavy workloads using read replicas and virtual endpoints — the same pattern OpenAI relies on to run ChatGPT on Postgres. Scott and Paula show a live read workload saturating a primary, then offload it to a replica with a single hostname change, and finish with replicas across Europe staying within milliseconds of the primary. It's read scale-out without sharding or re-architecting your app. Chapters 00:30 - Introduction 01:55 - Why read replicas: read/write asymmetry 03:45 - Architecture: primary, replicas, and virtual endpoints 05:30 - Demo: the cluster and a read-only replica 10:28 - Baseline: saturating the primary 13:53 - The flip: offloading reads to a replica 16:48 - Wrap up Recommended resources Read replicas in Azure Database for PostgreSQL Azure Database for PostgreSQL Demo script Connect Scott Hanselman | Twitter/X: @SHanselman Paula Berenguel | LinkedIn: paulaberenguel Azure Friday | Twitter/X: @AzureFriday Azure | Twitter/X: @Azure
Get every episode summarized
Each time Azure Friday publishes, we email you a written briefing from the transcript — the topics, who appeared, and any specific claims, with the ad reads skipped.
Email me new episodesFree for 3 shows. No card needed.
Hosts & guests
No transcript yet
This episode has not been transcribed. Request it and it moves to the front of the queue.
More episodes
More from Azure Friday
Deploying Aspire Apps to Azure App Service for Linux
Azure Friday
Turning Coding Agents into an Azure Cosmos DB Expert with the Agent Kit
Azure Friday
Meet Azure HorizonDB, the new Postgres on Azure
Azure Friday
Observe and evaluate agents for quality and safety in Microsoft Foundry
Azure Friday