Create/Drop a database index without locking the table's selects, inserts, etc. on PostgreSQL

postgres-create-drop-index-without-locking.sql

CREATE INDEX CONCURRENTLY your_index_name on your_table_name (your_column_name);

DROP INDEX CONCURRENTLY your_index_name;