PostgreSQL 18 · Performance and maintenance
Create an index without blocking writes
Build the index while the table stays writable. Slower, and it cannot run inside a transaction.
CREATE INDEX CONCURRENTLY idx_users_email ON users (email);
Official PostgreSQL 18 documentation
More performance and maintenance commands
- See how a query runs
- Create an index
- Vacuum and update statistics
- See running queries
- Cancel a running query
All performance and maintenance commands · PostgreSQL 18 cheatsheet