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.

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

Improve the wide table's statistics collecting #27358

Open
winoros opened this issue Aug 18, 2021 · 0 comments
Open

Improve the wide table's statistics collecting #27358

winoros opened this issue Aug 18, 2021 · 0 comments
Assignees
Labels
sig/planner SIG: Planner type/feature-request Categorizes issue or PR as related to a new feature.

Comments

@winoros
Copy link
Member

winoros commented Aug 18, 2021

Feature Request

Is your feature request related to a problem? Please describe:

Two data found during test.
When we analyze a table with 60 million rows and about 10 columns(with indexes), it costs 59s.
When we analyze a table with 10 million rows and about 369 columns(with indexes), it costs 3min.

It shows that when the number of columns increases, the analyze time is heavily increased.

Describe the feature you'd like:

We need to find a way to improve the analyze strategy for the wide table to make sure that we can get a tolerable execution time for a wide table. (We may analyze a table with hours when it's huge and wide)

Describe alternatives you've considered:

Teachability, Documentation, Adoption, Migration Strategy:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
sig/planner SIG: Planner type/feature-request Categorizes issue or PR as related to a new feature.
Projects
None yet
Development

No branches or pull requests

2 participants