They Enabled Postgres Partitioning and their Backend fell apart
The Backend Engineering Show with Hussein NasserShow Notes
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
More from The Backend Engineering Show with Hussein Nasser
I discuss the state of what will be happening in the coming few years and why I encourage the 3 of you who want to be elite engineers to keep their critical thinking sharp. To pause and think before prompting.
This is a conversation with Rashed Hasan, a PhD Candidate from the University of Nebraska. We chatted about databases, ORMs and how to use AI without losing yourself. Rashed pagehttps://www.mdrashedulhasan.me/homepage
I discuss loops engineering and how it will numb creative thinking and critical system design for engineers.
I like SQL but the standard should have included ways to hint instead of the abstraction of "let me do it for you"
In this episode I explore why you should take some time to examine the operation you are caching before doing so. And why caching is a cop-out