tubeshowcase●1,671,250 videos♡ My collection 0
← Learn to Code

Learn to Code29:43

Overcoming Performance Hurdles in Postgres Partitioned Tables | POSETTE: An Event for Postgres 2025

Microsoft Developer ↗

From the creator

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.

Keep exploring Learn to Code