Azure Database for PostgreSQL Flexible Server - Elastic Clusters, faster disks, and AI updates

Increase scalability, optimize performance, and integrate advanced AI features with Azure Database for PostgreSQL Flexible Server. Scale up with SSD v2 for up to 4x more transactions per second and significantly lower latency. Scale out effortlessly with elastic clusters using Citus, distributing workloads across multiple servers at no extra cost. Optimize performance with Automatic Index Tuning, reducing server utilization and enhancing efficiency. Leverage advanced AI features like DiskANN, semantic reranking, and Graph RAG to build better AI apps.
Charles Feddersen, Partner Director of Program Management for Postgres at Microsoft, joins Jeremy Chapman to show you how to build scalable, high-performance AI apps on Azure PostgreSQL Flexible Server today.
► QUICK LINKS:
00:00 - Azure Database for Postgres Flexible Server
00:39 - Updates to PostGreSQL
01:50 - Faster storage with SSD v2
03:06 - Scale out workloads using elastic cluster
03:59 - Provision an elastic cluster
05:34 - Scale "in-place"
07:12 - Eliminate redundant indexes
07:44 - Optimize server parameters
09:52 - Improve AI apps with Postgres Flexible Server
11:40 - Code behind queries using PG Admin
12:31 - Scale workloads
13:36 - Wrap up
► Link References
Get started at https://aka.ms/azurepostgresblog
Access code at https://aka.ms/AzurePostgresAI
► Unfamiliar with Microsoft Mechanics?
As Microsoft's official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft.
• Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries
• Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog
• Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/podcast
► Keep getting this insider knowledge, join us on social:
• Follow us on Twitter: https://twitter.com/MSFTMechanics
• Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/
• Enjoy us on Instagram: https://www.instagram.com/msftmechanics/
Published on:
Learn more
Made for tech enthusiasts and IT professionals. Expanded coverage of your favorite technologies across Microsoft; including Office, Azure, Windows and Data Platforms. We'll even bring you broader topics such as device innovation with Surface, machine learning, and predictive analytics.
Related posts
Innovation with Azure OpenAI Service
Authentication for Astro with Azure Static Web Apps
Azure Static Web Apps provides built-in authentication and authorization capabilities, making it easy to secure your Astro site and API endpoi...
Deep Dive into Azure AI Foundry
Integrating Azure Functions into your Astro site
In the previous post, I showed you how to deploy your Astro site to Azure Static Web Apps using the Azure Static Web Apps (SWA) CLI. In this p...
Azure DevOps Basic usage included with GitHub Enterprise
Many customers want to use both GitHub and Azure DevOps together. Until now, unless you purchased Visual Studio subscriptions with GitHub Ente...
Deploy Astro to Azure Static Web Apps from GitHub and CLI
Deploying an Astro site to Azure Static Web Apps should be straightforward, but my initial experience was not pain-free. The default Oryx GitH...
GPT-4.5 preview is available in Azure AI Foundry
Microsoft just released the information that GPT-4.5 preview model is available for deployment at Azure AI Foundry! Not everyone can yet use t...
Azure SDK Release (February 2025)
Azure SDK releases every month. In this post, you find this month's highlights and release notes. The post Azure SDK Release (February 2025) a...