create-an-index-without-blocking.md

Create An Index Without Blocking

Category: Postgres

Indexes can be created in Postgres without holding a lock on a table.

CREATE INDEX CONCURRENTLY tablename_columnname_idx ON tablename (columnname);

This operation can not be performed inside a transaction.