
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