During a normal index creation, table updates are blocked, but reads are still allowed.
CONCURRENTLY avoids locking the table against writes during index creation.
Ensure all index creations use the
This rule ignores indexes added to tables created in the same transaction.
In a concurrent index build, the index is actually entered as an “invalid” (details)