/postgres-create-drop-index-without-locking.sql
Forked from okanmenevseoglu/postgres-create-drop-index-online.sql
Last active Mar 10, 2018
Create/Drop a database index without locking the table's selects, inserts, etc. on PostgreSQL
| CREATE INDEX CONCURRENTLY your_index_name on your_table_name (your_column_name); | |
| DROP INDEX CONCURRENTLY your_index_name; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment