Skip to content

internal/rangekey: enforce iterator bounds beneath defragmentation#1866

Merged
jbowens merged 1 commit intocockroachdb:masterfrom
jbowens:defrag-opt
Aug 11, 2022
Merged

internal/rangekey: enforce iterator bounds beneath defragmentation#1866
jbowens merged 1 commit intocockroachdb:masterfrom
jbowens:defrag-opt

Conversation

@jbowens
Copy link
Copy Markdown
Contributor

@jbowens jbowens commented Aug 10, 2022

Enforce iterator bounds beneath defragmentation to avoid unnecessary range-key
block loads.

name                             old time/op    new time/op    delta
CombinedIteratorSeek_Bounded-10    2.77ms ± 1%    0.05ms ± 2%  -98.23%  (p=0.000 n=10+20)

name                             old alloc/op   new alloc/op   delta
CombinedIteratorSeek_Bounded-10    1.79MB ± 0%    0.02MB ± 0%  -98.89%  (p=0.000 n=10+19)

name                             old allocs/op  new allocs/op  delta
CombinedIteratorSeek_Bounded-10     17.0k ± 0%      0.1k ± 0%  -99.28%  (p=0.000 n=10+20)

Close #1861.

@jbowens jbowens requested a review from a team August 10, 2022 15:32
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

Enforce iterator bounds beneath defragmentation to avoid unnecessary range-key
block loads.

```
name                             old time/op    new time/op    delta
CombinedIteratorSeek_Bounded-10    2.77ms ± 1%    0.05ms ± 2%  -98.23%  (p=0.000 n=10+20)

name                             old alloc/op   new alloc/op   delta
CombinedIteratorSeek_Bounded-10    1.79MB ± 0%    0.02MB ± 0%  -98.89%  (p=0.000 n=10+19)

name                             old allocs/op  new allocs/op  delta
CombinedIteratorSeek_Bounded-10     17.0k ± 0%      0.1k ± 0%  -99.28%  (p=0.000 n=10+20)
```

Close cockroachdb#1861.
@erikgrinaker
Copy link
Copy Markdown
Contributor

Damn, those are some gains! 🚀

@jbowens jbowens requested a review from sumeerbhola August 10, 2022 18:37
Copy link
Copy Markdown
Contributor

@nicktrav nicktrav left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Very nice. :lgtm:

Reviewed 11 of 11 files at r1, all commit messages.
Reviewable status: :shipit: complete! all files reviewed, all discussions resolved (waiting on @erikgrinaker, @itsbilal, and @sumeerbhola)

Copy link
Copy Markdown
Contributor Author

@jbowens jbowens left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

TFTR!

Reviewable status: :shipit: complete! all files reviewed, all discussions resolved (waiting on @erikgrinaker, @itsbilal, and @sumeerbhola)

@jbowens jbowens merged commit 67f552b into cockroachdb:master Aug 11, 2022
@jbowens jbowens deleted the defrag-opt branch August 11, 2022 17:51
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

Successfully merging this pull request may close these issues.

db: respect bounds during range key defragmentation

4 participants