Skip to content

Instantly share code, notes, and snippets.

Avatar
🏠
Working from home

Okan Menevşeoğlu okanmenevseoglu

🏠
Working from home
View GitHub Profile
@okanmenevseoglu
okanmenevseoglu / postgres-create-drop-index-online.sql
Last active Jan 29, 2018
Create/Drop a database index online (without locking the table) on PostgreSQL
View postgres-create-drop-index-online.sql
CREATE INDEX CONCURRENTLY {indexName} ON {tableName} ({columnName});
DROP INDEX CONCURRENTLY {indexName};