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.

Read this page as plain markdown — no HTML, no navigation. For pasting into an LLM, or for an agent to fetch.