Họ Bật Phân Vùng Postgres và Backend của họ sụp đổ

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

https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join

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

https://www.youtube.com/playlist?list=UUMO_ML5xP23TOWKUcc-oAE_Eg

🏭 Backend Engineering Videos in Order

https://backend.husseinnasser.com

💾 Database Engineering Videos

https://www.youtube.com/playlist?list=PLQnljOFTspQXjD0HOzN7P2tgzu7scWpl2

🎙️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