Skip to content

sql/gcjob: set GC hint when deleting all data in range#86739

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
aliher1911:schema_gc_use_gc_hint
Sep 1, 2022
Merged

sql/gcjob: set GC hint when deleting all data in range#86739
craig[bot] merged 1 commit intocockroachdb:masterfrom
aliher1911:schema_gc_use_gc_hint

Conversation

@aliher1911
Copy link
Copy Markdown
Contributor

When deleting full range spans with range tombstones GC hint
should be set to reduce the work GC does when collecting those
ranges.
This commit add appropriate flag to the request.

Release justification: Enables future optimization for delete range only,
doesn't change current GC or delete range functionality.
Release note: None

@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

@aliher1911 aliher1911 force-pushed the schema_gc_use_gc_hint branch from 725e257 to e8e4e98 Compare August 26, 2022 11:28
@aliher1911 aliher1911 marked this pull request as ready for review August 26, 2022 11:29
@aliher1911 aliher1911 requested review from a team and ajwerner August 26, 2022 11:29
@aliher1911 aliher1911 self-assigned this Aug 26, 2022
@aliher1911
Copy link
Copy Markdown
Contributor Author

Follow up to adding hint: #86550

Copy link
Copy Markdown
Contributor

@erikgrinaker erikgrinaker left a comment

Choose a reason for hiding this comment

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

Let's set this in sql/planner.ForceDeleteTableData() too.

When deleting full range spans with range tombstones GC hint
should be set to reduce the work GC does when collecting those
ranges.
This commit add appropriate flag to the request.

Release justification: Enables future optimization for delete range only,
doesn't change current GC or delete range functionality.
Release note: None
@aliher1911 aliher1911 force-pushed the schema_gc_use_gc_hint branch from e8e4e98 to f318c48 Compare September 1, 2022 08:28
@aliher1911
Copy link
Copy Markdown
Contributor Author

bors r+

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Sep 1, 2022

Build failed:

@aliher1911
Copy link
Copy Markdown
Contributor Author

bors r+

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Sep 1, 2022

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Sep 1, 2022

Build succeeded:

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.

3 participants