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

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