Skip to content

[DocDB] Optimize 2nd phase of block-based sampling for ANALYZE #25579

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
Open
1 task done
ttyusupov opened this issue Jan 10, 2025 · 0 comments
Open
1 task done

[DocDB] Optimize 2nd phase of block-based sampling for ANALYZE #25579

ttyusupov opened this issue Jan 10, 2025 · 0 comments
Assignees
@ttyusupov
Labels
area/docdb YugabyteDB core features kind/enhancement This is an enhancement of an existing feature priority/low Low priority

Comments

@ttyusupov
Copy link
Contributor

ttyusupov commented Jan 10, 2025 •
edited by jira bot
Loading

Jira Link: DB-14834

Description

Currently on perf test env it takes ~47 seconds on ~135GB colocated table with 200M rows.
First phase for collecting sample blocks takes ~8 seconds and second phase which collects rows from sample blocks for the final sample takes ~37 seconds.

We need to improve 2nd phase performance to reduce ANALYZE query time further.

Issue Type

kind/enhancement

Warning: Please confirm that this issue does not contain any sensitive information

  • I confirm this issue does not contain any sensitive information.
@ttyusupov ttyusupov added area/docdb YugabyteDB core features status/awaiting-triage Issue awaiting triage labels Jan 10, 2025
@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue labels Jan 10, 2025
@yugabyte-ci yugabyte-ci removed the status/awaiting-triage Issue awaiting triage label Jan 14, 2025
@yugabyte-ci yugabyte-ci added priority/low Low priority and removed priority/medium Medium priority issue labels Apr 1, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ttyusupov ttyusupov

Labels
area/docdb YugabyteDB core features kind/enhancement This is an enhancement of an existing feature priority/low Low priority
Projects
YBase features
Status: Backlog
Milestone
No milestone
Development

No branches or pull requests
2 participants
@ttyusupov @yugabyte-ci