Fixing a hang when upserting 90,000 rows with :batchexec #2029
Unanswered
austincollinpena
asked this question in
General
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.
-
Maybe this will help someone in the future!
I dealt with a situation, of unknown cause, where a :batchexec would cause the program to stall. I don't know why it would happen, but I found a fix.
I chunked the bulk insert arguments (https://stackoverflow.com/a/72408490) and ran them concurrently inside of an errGroup.
Fixing the root cause is better but this works for now!
Beta Was this translation helpful? Give feedback.
All reactions