What kind of lock does the “create index” (not concurrent) command take? From the documentation, it says that it blocks out writes. But I’m not sure how to find the exact lock type in the documentation.
The reason I’m asking is because I’m trying to see if it conflicts with the lock taken by autovacuum (to prevent wraparound), “SHARE UPDATE EXCLUSIVE”.
