
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
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.