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.

Sign up for GitHub

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

Jump to bottom

storage,kv: improve the performance intent resolution over a key range #66900

Closed
lunevalex opened this issue Jun 25, 2021 · 0 comments · Fixed by #66268
Closed

storage,kv: improve the performance intent resolution over a key range #66900

lunevalex opened this issue Jun 25, 2021 · 0 comments · Fixed by #66268
Assignees
@sumeerbhola
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) C-performance Perf of queries or internals. Solution not expected to change functional behavior. N-followup Needs followup. O-postmortem Originated from a Postmortem action item. T-storage Storage Team

Comments

@lunevalex
Copy link
Collaborator

Now that we have introduced a separated lock table in #41720. We can significantly improve intent resolution for transactions
that write many intents such that we track intent ranges. This can result in close to 100x performance improvement in range intent resolution.

Epic: CRDB-8282
@lunevalex lunevalex added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-postmortem Originated from a Postmortem action item. T-storage Storage Team N-followup Needs followup. labels Jun 25, 2021
@lunevalex lunevalex added the C-performance Perf of queries or internals. Solution not expected to change functional behavior. label Jun 25, 2021
@lunevalex lunevalex mentioned this issue Jun 25, 2021
Merged
@craig craig bot closed this as completed in 01b9e69 Sep 1, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@sumeerbhola sumeerbhola

Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) C-performance Perf of queries or internals. Solution not expected to change functional behavior. N-followup Needs followup. O-postmortem Originated from a Postmortem action item. T-storage Storage Team
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

storage,kv: faster intent resolution over a key range sumeerbhola/cockroach
2 participants
@sumeerbhola @lunevalex