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

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.