ColumnIndexOptions.concurrently property

Builds the index without locking writes out of the table.

Signature:

concurrently: boolean;

Remarks

Applied to the drop as well as the create. Postgres refuses to run either inside a transaction, and a concurrent build that fails leaves an invalid index behind to be dropped by hand — the price of not blocking a live table.