All Postgres Locks Explained | A Deep Dive
The Backend Engineering Show with Hussein Nasser
00:00
The Most Important Box Is Share Update Exclusive
Vacuum is interesting to me. You want to be able to run vacuum so you can freeze transactions as you continue such that you can run as often as possible. The only time vacuum will be blocked, which is this guy is if you do a share update exclusive, what the heck is that? It's the same thing. Of course, it doesn't make sense, right? If you, if you reindex concurrently, for example, right? It's like, okay, my table, my index is corrupt. I just want to reindex it, just throw everything away and just, but reindex everything,. That will prevent you from running vacuums, which is dangerous
Transcript
Play full episode
