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 Performance Degradation in Post Chris Version 13

If you're querying even a single order on a specific date, let's say I want to pick, give me the order on this day. That's it. Just give me that order on the day. But what if I select one row? Here is where a performance degradation in post Chris version 13, which is what they are on, right? Exists. Fortunately, something has been fixed in post Chris 14. Despite my effort to explicitly limit queries to specific partition ranges, the database continued to enforce locks on every partition. So many logs creates contention. At this part, at this point, we had 40 partition. Now, it times 22 times 22 23, if you have

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