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

Enhancement for analyze partition table in dynamic prune mode #37977

Closed
Yisaer opened this issue Sep 20, 2022 · 0 comments
Closed

Enhancement for analyze partition table in dynamic prune mode #37977

Yisaer opened this issue Sep 20, 2022 · 0 comments
Assignees
@Yisaer
Labels
sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.

Comments

@Yisaer
Copy link
Contributor

Yisaer commented Sep 20, 2022 •
edited
Loading

Enhancement

  1. Analyzing single partition takes too long in dynamic prune mode comparing static prune mode
  2. Dumping partition table stats for partition table which has global stats is not necessary
  3. The statement would be too long for auto analyze partition table if it has many partitions.
@Yisaer Yisaer added the type/enhancement The issue or PR belongs to an enhancement. label Sep 20, 2022
@Yisaer Yisaer self-assigned this Sep 20, 2022
@Yisaer Yisaer added the sig/planner SIG: Planner label Sep 20, 2022
@Yisaer Yisaer mentioned this issue Sep 21, 2022
Merged
2 tasks
ti-chi-bot pushed a commit that referenced this issue Sep 22, 2022
@Yisaer
executor: remove loading unnecessary stats during analyze partition t…
e7d0c46 
…able in dynamic mode (#38028)

ref #37977
@Yisaer Yisaer mentioned this issue Sep 26, 2022
Merged
2 tasks
ti-chi-bot pushed a commit that referenced this issue Sep 27, 2022
@Yisaer
statistics: implement batch size for auto analyze partition table in …
47739ff 
…dynamic mode (#38153)

ref #37977
@Yisaer Yisaer mentioned this issue Sep 27, 2022
Merged
1 task
ti-chi-bot pushed a commit that referenced this issue Oct 28, 2022
@Yisaer
server: support dumpPartitionStats param for statsHandler (#38190)
636a363 
ref #37977
@Yisaer Yisaer closed this as completed Nov 1, 2022
@Yisaer Yisaer mentioned this issue Nov 2, 2022
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Yisaer Yisaer

Labels
sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@Yisaer