Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add option to run migration CONCURRENTLY for postgres #9

Open
tbicr opened this issue Jan 29, 2018 · 1 comment
Open

Add option to run migration CONCURRENTLY for postgres #9

tbicr opened this issue Jan 29, 2018 · 1 comment

Comments

@tbicr
Copy link

tbicr commented Jan 29, 2018

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.

@Ouradze
Copy link

Ouradze commented Mar 5, 2018

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants