
They Enabled Postgres Partitioning and their Backend fell apart
The Backend Engineering Show with Hussein Nasser
00:00
How to Manage Multiple Locks in a Table
Each partition has 22 indexes. Just querying, you get 2220 locks per query. Can you imagine the cost of this locking? So you need a lock manager to manage all of this thing. All of this started in a table called post, the post Chris lock stable. And there's a post the lock manager, manage all this stuff. You can see that it's not cheap to manage many, many, many locks.
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.