Cheat Sheet logoCheat Sheet Today
PostgreSQL Cheat Sheet/Create index concurrently

Build an index with reduced write blocking.

Back to sheetBrowse commands
Sign in to save
Section: Indexes and Constraints

Create index concurrently

sql
sql
CREATE INDEX CONCURRENTLY idx_orders_created_at ON orders (created_at);
Explanation

Use outside a transaction block.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Indexes and Constraints
Create index
Add a basic B-tree index to speed lookups.
OpenIn sheetsqlsame section
Create partial index
Index only a subset of rows.
OpenIn sheetsqlsame section
Create unique index
Enforce uniqueness with an index.
OpenIn sheetsqlsame section
Create expression index
Index an expression for case-insensitive lookups.
OpenIn sheetsqlsame section
Create GIN index on JSONB
Accelerate JSONB containment queries.
OpenIn sheetsqlsame section
Drop index
Remove an index that is no longer needed.
OpenIn sheetsqlsame section