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

Optimize count() with time range #4818

Open
shuiyisong opened this issue Oct 11, 2024 · 0 comments
Open

Optimize count() with time range #4818

shuiyisong opened this issue Oct 11, 2024 · 0 comments
Assignees
@waynexia
Labels
C-enhancement Category Enhancements C-performance Category Performance

Comments

@shuiyisong
Copy link
Contributor

What type of enhancement is this?

Performance

What does the enhancement do?

Under append mode, a query like select count(*) from table where ts between a and b should use statistics information of SSTs in between and only scan head and tail ones that include the TS boundary. This should improve the performance of the count() query by large.

Implementation challenges

No response
@shuiyisong shuiyisong added C-enhancement Category Enhancements C-performance Category Performance labels Oct 11, 2024
@waynexia waynexia self-assigned this Oct 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@waynexia waynexia

Labels
C-enhancement Category Enhancements C-performance Category Performance
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@waynexia @shuiyisong