Nov 22, 2024
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/