create new index takes long time postgresql
snippet in sql

create new index takes long time postgresql

user7283

Create index with concurrency : 
CREATE INDEX CONCURRENTLY users_name_idx ON users(name);