In a wonderful blog, Kyle explores the pains he faced managing a Postgres instance for a startup he works for and how enabling partitioning sigintfically created wait events causing the backend and subsequently NGINX to through 500 errors. We discuss this in this video/podcast https://www.kylehailey.com/post/postgres-partition-pains-lockmanager-waits 0:00 Intro 3:30 Background 6:30 April 1st The partitioning 8:30 May 6th things went south 10:30 April 11 The start of the waits 12:00 Locks 15:30 High volume of locks 17:30 The Problem with Postgres 13 20:00 Fastpath locking 24:00 Moving to Weekly Partitions 31:30 Summary Discovering Backend Bottlenecks: Unlocking Peak Performance https://performance.husseinnasser.com/ Fundamentals of Backend Engineering Design patterns udemy course (link redirects to udemy with coupon) https://backend.husseinnasser.com/ Fundamentals of Networking for Effective Backends udemy course (link redirects to udemy with coupon) https://network.husseinnasser.com/ Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon) https://database.husseinnasser.com/ Follow me on Medium https://medium.com/@hnasr/membership Introduction to NGINX (link redirects to udemy with coupon) https://nginx.husseinnasser.com/ Python on the Backend (link redirects to udemy with coupon) https://python.husseinnasser.com/ Become a Member on YouTube null Buy me a coffee if you liked this https://www.buymeacoffee.com/hnasr Arabic Software Engineering Channel https://www.youtube.com/channel/UChWZsjdoRvZ0T9QWZOD6UpA 🔥 Members Only Content    • Members-only videos   🏭 Backend Engineering Videos in Order https://backend.husseinnasser.com/ 💾 Database Engineering Videos    • Database Engineering   🎙️Listen to the Backend Engineering Podcast https://husseinnasser.com/podcast Gears and tools used on the Channel (affiliates) 🖼️ Slides and Thumbnail Design Canva https://partner.canva.com/c/2766475/647168/10068 Stay Awesome, Hussein