Skip to content

catalog: protobuf and cluster versioning for table statistics forecasts#79025

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
michae2:forecastStatsProto
Mar 31, 2022
Merged

catalog: protobuf and cluster versioning for table statistics forecasts#79025
craig[bot] merged 1 commit intocockroachdb:masterfrom
michae2:forecastStatsProto

Conversation

@michae2
Copy link
Copy Markdown
Collaborator

@michae2 michae2 commented Mar 30, 2022

Add a field to the TableDescriptor for per-table statistics forecasting.
We'll want this when backporting statistics forecasts to 22.1.

Release note: None

@michae2 michae2 requested review from a team March 30, 2022 05:16
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

@michae2
Copy link
Copy Markdown
Collaborator Author

michae2 commented Mar 30, 2022

(Note that the first commit is #79009 which can be ignored.)

Copy link
Copy Markdown
Contributor

@msirek msirek left a comment

Choose a reason for hiding this comment

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

Looks good to me. I'll leave it to the experts to approve it though.

Reviewable status: :shipit: complete! 0 of 0 LGTMs obtained (waiting on @ajwerner, @postamar, and @rytaft)

Copy link
Copy Markdown
Collaborator

@rytaft rytaft left a comment

Choose a reason for hiding this comment

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

:lgtm: (but wait for either @ajwerner or @postamar)

Reviewed 7 of 7 files at r1, 7 of 7 files at r2, all commit messages.
Reviewable status: :shipit: complete! 1 of 0 LGTMs obtained (waiting on @ajwerner and @postamar)

Add a field to the TableDescriptor for per-table statistics forecasting.
We'll want this when backporting statistics forecasts to 22.1.

Release note: None
@michae2 michae2 force-pushed the forecastStatsProto branch from 63cbb77 to 9f1d234 Compare March 30, 2022 16:12
Copy link
Copy Markdown
Contributor

@mgartner mgartner left a comment

Choose a reason for hiding this comment

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

Reviewed 7 of 7 files at r2, all commit messages.
Reviewable status: :shipit: complete! 0 of 0 LGTMs obtained (and 1 stale) (waiting on @ajwerner and @postamar)

Copy link
Copy Markdown
Contributor

@ajwerner ajwerner left a comment

Choose a reason for hiding this comment

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

:lgtm:

Reviewable status: :shipit: complete! 1 of 0 LGTMs obtained (and 1 stale) (waiting on @postamar)

Copy link
Copy Markdown
Collaborator

@rytaft rytaft left a comment

Choose a reason for hiding this comment

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

Thanks!

bors r+

Reviewed all commit messages.
Reviewable status: :shipit: complete! 1 of 0 LGTMs obtained (and 1 stale) (waiting on @postamar)

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Mar 31, 2022

This PR was included in a batch that was canceled, it will be automatically retried

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Mar 31, 2022

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Mar 31, 2022

Build succeeded:

@craig craig bot merged commit 430a78b into cockroachdb:master Mar 31, 2022
@michae2 michae2 deleted the forecastStatsProto branch March 31, 2022 17:42
michae2 added a commit to michae2/cockroach that referenced this pull request Aug 27, 2022
Add a new storage parameter (a.k.a. table setting) which can be used to
override cluster setting `sql.stats.forecasts.enabled`. This builds on
work done earlier in cockroachdb#79025 and cockroachdb#86932 so we don't have to do much, just
wire it all together.

Fixes: cockroachdb#86353

Release justification: Low-risk update to new functionality.

Release note (sql change): Add a new table setting
`sql_stats_forecasts_enabled` which controls whether statistics
forecasts are generated for a specific table. When set, this overrides
cluster setting `sql.stats.forecasts.enabled`.
michae2 added a commit to michae2/cockroach that referenced this pull request Aug 28, 2022
Add a new storage parameter (a.k.a. table setting) which can be used to
override cluster setting `sql.stats.forecasts.enabled`. This builds on
work done earlier in cockroachdb#79025 and cockroachdb#86932 so we don't have to do much, just
wire it all together.

Fixes: cockroachdb#86353

Release justification: Low-risk update to new functionality.

Release note (sql change): Add a new table setting
`sql_stats_forecasts_enabled` which controls whether statistics
forecasts are generated for a specific table. When set, this overrides
cluster setting `sql.stats.forecasts.enabled`.
craig bot pushed a commit that referenced this pull request Aug 28, 2022
86986: sql/stats: add table setting to disable generation of stats forecasts r=rytaft,msirek a=michae2

Add a new storage parameter (a.k.a. table setting) which can be used to
override cluster setting `sql.stats.forecasts.enabled`. This builds on
work done earlier in #79025 and #86932 so we don't have to do much, just
wire it all together.

Fixes: #86353

Release justification: Low-risk update to new functionality.

Release note (sql change): Add a new table setting
`sql_stats_forecasts_enabled` which controls whether statistics
forecasts are generated for a specific table. When set, this overrides
cluster setting `sql.stats.forecasts.enabled`.

Co-authored-by: Michael Erickson <michae2@cockroachlabs.com>
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.

6 participants