Concepts
>
Attributes (MetaAttributes)
> CONCURRENTLY \ PostgreSQL
CONCURRENTLY \ PostgreSQL
Drop the index without locking out concurrent selects, inserts, updates, and deletes on the index's
table. A normal DROP INDEX acquires exclusive lock on the table, blocking other accesses until
the index drop can be completed. With this option, the command instead waits until conflicting
transactions have completed.
Translations
Type
Boolean (2) Standard
List of MetaClasses
SQL Clause
.
This site works best with JavaScript enabled