They Enabled Postgres Partitioning and their Backend fell apart @hnasr
They Enabled Postgres Partitioning and their Backend fell apart  @hnasr
Uploaded June 2023 | Updated November 2026, 2 hours ago
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

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
performance.husseinnasser.com

Fundamentals of Backend Engineering Design patterns udemy course (link redirects to udemy with coupon)
backend.husseinnasser.com

Fundamentals of Networking for Effective Backends udemy course (link redirects to udemy with coupon)
network.husseinnasser.com

Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon)
database.husseinnasser.com

Follow me on Medium
medium.com/@hnasr/membership


Introduction to NGINX (link redirects to udemy with coupon)
nginx.husseinnasser.com

Python on the Backend (link redirects to udemy with coupon)
python.husseinnasser.com

Become a Member on YouTube
youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join

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

Arabic Software Engineering Channel
youtube.com/channel/UChWZsjdoRvZ0T9QWZOD6UpA

🔥 Members Only Content
youtube.com/playlist?list=UUMO_ML5xP23TOWKUcc-oAE_Eg



🏭 Backend Engineering Videos in Order
backend.husseinnasser.com

💾 Database Engineering Videos
youtube.com/playlist?list=PLQnljOFTspQXjD0HOzN7P2tgzu7scWpl2

🎙️Listen to the Backend Engineering Podcast
husseinnasser.com/podcast

Gears and tools used on the Channel (affiliates)

🖼️ Slides and Thumbnail Design
Canva
partner.canva.com/c/2766475/647168/10068


Stay Awesome,
Hussein
They Enabled Postgres Partitioning and their Backend fell apartUpgrading to MySQL 8? Watch out for thisWhat are page tables?Backends can now process requests faster now in LinuxPostgreSQL 18 Asynchronous I OKernel Software vs Hardware TLSPage Tables | The Backend Engineering ShowHTTP Graceful shutdown | The Backend Engineering ShowShould you build backend from scratchTranslation Lookaside bufferWebSockets is not freeWhere http2 hits its limit
Hussein Nasser |

They Enabled Postgres Partitioning and their Backend fell apart

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER