What Happens When You Delete a Row, Share Update Exclusive?

The table is marked as role exclusive for that transaction. If you do emerge and insert an update, this is acquired at the table level. And I will tell you what can and can't be done. The moment you do that or select, you can't re index the table,. Because that conflicts with anything. This mode protects the table against concurrent Schema changes in vacuum runs. It talks with exclusive, which we didn't talk about yet. We don't know what share is yet. So no two vacuum scan run this at the same time. Right.

Transcript

Play full episode

Remember Everything You Learn from Podcasts

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