All Postgres Locks Explained | A Deep Dive
The Backend Engineering Show with Hussein Nasser
00:00
Create Index Concurrently Acquires Share Lock on the Table
The create index will acquire share lock on the table. When you do that, you can't do any updates or insert or delete to your table. And also it conflict with share row exclusive, which we talked about. This one protects a table against concurrent data changes and is self exclusive. So I'm not really interested in this much exclusive.
Transcript
Play full episode
