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

que_jobs table will be locked from updates during migrations' index creation #342

Open
ZimbiX opened this issue Feb 25, 2022 · 0 comments
Open

Comments

@ZimbiX
Copy link
Member

ZimbiX commented Feb 25, 2022

It's just occurred to me that the index creation on que_jobs in the migrations for v1.3.0 (#334) and v2 (#319) will lock the que_jobs table from updates for the period of creating the index. This could be a problematically long time for people who have a big que_jobs table.

We can't just change them to use CREATE INDEX CONCURRENTLY (CIC), since a migration runs in a transaction, and CIC doesn't work in a transaction. We could modify them to use IF NOT EXISTS, so if needed, someone could manually run a CIC version of the index creation before applying the migration.

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

1 participant