Sign in to confirm you’re not a bot
This helps protect our community. Learn more

PostgreSQL - Performance updates, Elastic Clusters (Citus) & AI controls in Azure

Microsoft Mechanics
358K subscribers
<__slot-el>
<__slot-el>
6.5K views 4 months ago High-Performance Databases | Scale & Accelerate Your Data Workloads on Azure | Microsoft Mechanics
Optimize performance, increase scalability, and integrate advanced AI features with 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 - Performance upgrades to PostgreSQL 01:50 - Faster storage with SSD v2 03:06 - Scale-out workloads using Elastic Cluster, based on Citu …...more
...more
PostgreSQL - Performance updates, Elastic Clusters (Citus) & AI controls in Azure
129Likes
6,505Views
Nov 192024
Optimize performance, increase scalability, and integrate advanced AI features with 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 - Performance upgrades to PostgreSQL 01:50 - Faster storage with SSD v2 03:06 - Scale-out workloads using Elastic Cluster, based on Citus 03:59 - How to create an Elastic Cluster 05:34 - Performance optimizations for scaling "in-place" 07:12 - Eliminating redundant indexes in PostgreSQL 07:44 - Optimizing server parameters in PostgreSQL 09:52 - Improvements for AI apps with Postgres Flexible Server 11:40 - Code behind queries using PG Admin 12:31 - Scaling 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:    / microsoftmechanicsseries   • Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t... • Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com... ► Keep getting this insider knowledge, join us on social: • Follow us on Twitter:   / msftmechanics   • Share knowledge on LinkedIn:   / microsoft-mechanics   • Enjoy us on Instagram:   / msftmechanics   • Loosen up with us on TikTok:   / msftmechanics   #PostgreSQL #Postgres #Azure #AIApps
7 episodes
High-Performance Databases | Scale & Accelerate Your Data Workloads on Azure | Microsoft Mechanics
Microsoft Mechanics

Follow along using the transcript.

Microsoft Mechanics

358K subscribers