The Backend Engineering Show with Hussein Nasser cover image

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

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app