EPISODE · May 31, 2026 · 8 MIN
How Database Partitioning Prevents Performance Meltdowns
from Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations · host Fexingo
Episode 22 of Database Tech with Fexingo: Lucas and Luna dive into the unsung hero of database scalability — partitioning. Using the real-world example of a mid-size e-commerce company that saw query latency spike from 50ms to 12 seconds under Black Friday traffic, they explain the difference between horizontal and vertical partitioning, why partition key selection is critical, and how range vs. hash partitioning affects query performance. They also discuss the 2025 PostgreSQL 17 update that introduced native list partitioning for better data locality. If you've ever wondered why your database slows down as data grows, this episode gives you the concrete strategy to fix it before it breaks. #DatabasePartitioning #SQL #NoSQL #Technology #PostgreSQL #DatabasePerformance #HorizontalPartitioning #VerticalPartitioning #RangePartitioning #HashPartitioning #PartitionKey #DataScalability #BlackFriday #EcommerceDatabase #QueryOptimization #FexingoBusiness #BusinessPodcast #DatabaseEngineering Keep every episode free: buymeacoffee.com/fexingo
What this episode covers
Episode 22 of Database Tech with Fexingo: Lucas and Luna dive into the unsung hero of database scalability — partitioning. Using the real-world example of a mid-size e-commerce company that saw query latency spike from 50ms to 12 seconds under Black Friday traffic, they explain the difference between horizontal and vertical partitioning, why partition key selection is critical, and how range vs. hash partitioning affects query performance. They also discuss the 2025 PostgreSQL 17 update that introduced native list partitioning for better data locality. If you've ever wondered why your database slows down as data grows, this episode gives you the concrete strategy to fix it before it breaks. #DatabasePartitioning #SQL #NoSQL #Technology #PostgreSQL #DatabasePerformance #HorizontalPartitioning #VerticalPartitioning #RangePartitioning #HashPartitioning #PartitionKey #DataScalability #BlackFriday #EcommerceDatabase #QueryOptimization #FexingoBusiness #BusinessPodcast #DatabaseEngineering Keep every episode free: buymeacoffee.com/fexingo
NOW PLAYING
How Database Partitioning Prevents Performance Meltdowns
No transcript for this episode yet
Similar Episodes
Mar 26, 2026 ·1m
Mar 19, 2026 ·34m
Feb 18, 2026 ·11m
Feb 11, 2026 ·45m