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

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.
App store bannerPlay store banner