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

opt: Allow automatic stats to be run on a per table basis #35497

Closed
awoods187 opened this issue Mar 7, 2019 · 2 comments
Closed

opt: Allow automatic stats to be run on a per table basis #35497

awoods187 opened this issue Mar 7, 2019 · 2 comments
Labels
A-sql-optimizer SQL logical planning and optimizations. C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)

Comments

@awoods187
Copy link
Contributor

Is your feature request related to a problem? Please describe.
Currently, automatic statistics apply to the entire cluster.

Having a per table toggle may allow somebody to bulk load into a staging table quickly and then move data around to tables more slowly where statistics are applied.

Some tables may need automatic statistics--others may not.

Describe the solution you'd like
Per table toggle to turn Automatic Statistics on or off.
@awoods187 awoods187 added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) A-sql-optimizer SQL logical planning and optimizations. labels Mar 7, 2019
@awoods187 awoods187 changed the title Allow automatic stats to be run on a per table basis opt: Allow automatic stats to be run on a per table basis Mar 13, 2019
@github-actions
Copy link

github-actions bot commented Jun 5, 2021

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
5 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

@rytaft
Copy link
Collaborator

rytaft commented Jun 8, 2021

This is a duplicate of #40989.

@rytaft rytaft closed this as completed Jun 8, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
A-sql-optimizer SQL logical planning and optimizations. C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@rytaft @yuzefovich @awoods187