They Enabled Postgres Partitioning and their Backend fell apart

Published: 23 June 2023
on channel: Hussein Nasser

45,872

1.1k

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/postg...

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
  / 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
   / @hnasr

Buy me a coffee if you liked this
https://www.buymeacoffee.com/hnasr

Arabic Software Engineering Channel
   / @husseinnasser

🔥 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/6...

Stay Awesome,
Hussein

Watch video They Enabled Postgres Partitioning and their Backend fell apart online without registration, duration hours minute second in high quality. This video was added by user Hussein Nasser 23 June 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 45,872 once and liked it 1.1 thousand people.