09:23Announcements across Microsoft SQL at Microsoft Ignite 2026 | Data Exposed
Microsoft Developer
Video of a conference talk in which you'll learn about two prevalent performance issues encountered with partitioned tables in Postgres. The learnings shared in this talk are based on my experience working with diverse customer workloads in Azure, but these issues are relevant for anyone using Postgres partitioned tables, particularly those of you who manage vast data volumes or high traffic. High Query Planning Time on Large Partitioned Tables: High query planning time on tables with very large numbers of partitions (5000+), where the optimizer is not able to identify the partition key till the execution time leads to planning time greater than execution time. LW Lock Manager Wait Events: In highly concurrent environments, queries that don't use the partition key can trigger LW Lock Manager wait events, leading to higher CPU utilization (sometimes as much as 100%) and lower TPS. Sarat Balijapelli has 18+ years of experience working on Oracle and Postgres databases. He is currently working as a Senior Engineering Manager leading the performance charter in Azure Postgres team. ► Video bookmarks: ⏩ 00:08 Introduction - Postgres Partitioning Challenges ⏩ 01:36 What is Partitioning & Why is it Important? ⏩ 04:00 Types of Partitioning ⏩ 07:06 Partition Pruning ⏩ 11:39 Scenarios where Pruning Does not Happen ⏩ 14:07 What is Equivalence Class? ⏩ 16:38 Common Partitioning Challenges ⏩ 23:13 Solutions ⏩ 26:30 What is new in Postgres 18 📕 Everything you nee
Published 2025-06-12 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.
09:23Microsoft Developer
05:34
02:05
02:17
10:51SyntaxPilot
08:20
04:59IIMTRobot
Allow Google Analytics to measure visits. Your history stays in your browser. Privacy details