Glossary: PostgreSQL Beyond the Basics

CREATE INDEX CONCURRENTLY

Also written: CONCURRENTLY, DROP INDEX CONCURRENTLY

A way to build or drop an index without blocking writes on the table. It takes longer and can't run inside a transaction block.