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

PR #108139 - sql: fix logic to collect stats on system.jobs #17618

Open
cockroach-teamcity opened this issue Aug 6, 2023 · 0 comments
Open

PR #108139 - sql: fix logic to collect stats on system.jobs #17618

cockroach-teamcity opened this issue Aug 6, 2023 · 0 comments
Assignees
@taroface
Labels
C-product-change master

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Aug 6, 2023 •
edited by exalate-issue-sync bot

Exalate commented:

Related PR: cockroachdb/cockroach#108139
Commit: cockroachdb/cockroach@fe2e250
Informs: CRDB-30024

Release note (performance improvement): We now automatically collect
table statistics on the system.jobs table, which will enable the optimizer
to produce better query plans for internal queries that access the
system.jobs table. This may result in better performance of the system.
Note: a previous attempt to enable stats on system.jobs starting in 23.1.0
was unsuccessful, but we have now fixed the oversight.

Jira Issue: DOC-8493
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@taroface taroface

Labels
C-product-change master
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@taroface @cockroach-teamcity