Is it possible to 'restart' or 'resume' a migration and pick up backfilling from where it left off? #1023
Unanswered
danerubado-wk
asked this question in
Q&A
Is it possible to 'restart' or 'resume' a migration and pick up backfilling from where it left off?
#1023
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
My team is looking into using this tool for updating a private key from int -> bigint.
The backfill of the replacement column is going to take a considerably long time - we ran the intended 'start' migration on a dev environment with 37 million rows and it took about 100 minutes.
The production database is closing in on 2 billion rows (hence the need for bigint 😅). Assuming the same speed as we saw on development it would take something like 2.5 days to run. This is a long time to count on a process to run without interruption.
Considering that my question is this - are there any mechanisms with this tool to restart a particular migration such that it will continue backfilling from where it left off? Or is the only option via pgroll to rollback and start from the top?
Beta Was this translation helpful? Give feedback.
All reactions