django-partial-index icon indicating copy to clipboard operation
django-partial-index copied to clipboard

Add option to run migration `CONCURRENTLY` for postgres

Open tbicr opened this issue 7 years ago • 1 comments

For huge table when you create/drop index on live table for postgres, index creation lock table and for live you can just lock all enable connections and go to downtime when index will be created. So for this cases good case to use CONCURRENTLY.

tbicr avatar Jan 29 '18 14:01 tbicr

Also, when running a transaction concurrently, we may need to change the migration so that the create is run outside a transaction.

Ouradze avatar Mar 05 '18 10:03 Ouradze