PostgreSQL Create Index Concurrently
CREATE INDEX CONCURRENTLY idx_kx_kq_storeinandout_time_status on public.kx_kq_storeinandout USING btree(signintime,platstatus);
create UNIQUE INDEX CONCURRENTLY idx_unique_id on t1 using btree(id);
PostgreSQL Create Index Concurrently - 青空如璃 - 博客园 (cnblogs.com)
用一个例子来演示会更加清晰