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

Split SQL transactions for touches #253

Open
awfm9 opened this issue Sep 2, 2022 · 0 comments
Open

Split SQL transactions for touches #253

awfm9 opened this issue Sep 2, 2022 · 0 comments

Comments

@awfm9
Copy link
Contributor

awfm9 commented Sep 2, 2022

When we have a big SQL transaction for touches running on the parsing dispatcher, while the additions are being executed, it will keep running the transaction until the additions are done. If we encounter a Postgres deadlock, we could split the transaction into smaller and smaller parts, until we can apply all of them, to give them a higher chance of succeeding concurrently.

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