
They Enabled Postgres Partitioning and their Backend fell apart
The Backend Engineering Show with Hussein Nasser
00:00
The Importance of Index Management in Gen X
When he was moving the seven partitions into one weekly, we're inserting, right? Remember, we have what we have essentially 22 indexes. By dropping the index, he created an access exclusive lock on the table. I don't think that query be that table was not queried actively there. But the fact that he's dropping the index,. essentially created more problems for him, because now locking contention started to happen more locking and more locking. And this is exactly what happened back to the video. Oh, look at that, they are using in Gen X, as a gateway. So this is where it says a gateway errors, which is in Gen X uses the back end, the back
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.