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

[YSQL] [Perf][Microbenchmark] Regression seen in scan query returning 1000 rows, between 2.19.1.0-b386 and 2.19.1.0-b388 #18626

Closed
1 task done
sonalsagarwal opened this issue Aug 9, 2023 · 0 comments
Closed
1 task done

[YSQL] [Perf][Microbenchmark] Regression seen in scan query returning 1000 rows, between 2.19.1.0-b386 and 2.19.1.0-b388 #18626

sonalsagarwal opened this issue Aug 9, 2023 · 0 comments
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue status/awaiting-triage Issue awaiting triage

Comments

@sonalsagarwal
Copy link

sonalsagarwal commented Aug 9, 2023 •
edited by jira bot

Jira Link: DB-7553

Description

This is observed in nightly regression for microbencmark runs.
Regression in scanG4 workload , the latency for "scanG4_pkey_INclause_rangescan_increasing_rows_1000row" has increased about by 3x. The impact seems to be only on query returning 1000 rows, the other queries returning 1 / 10 / 100 rows don't have any impact.
The avg. latency for query returning 1000 rows was 5.67ms in 2.19.1.0-b386 and 17ms in 2.19.1.0-b388 (increased by 3x). Please check this comparison report.

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

  • I confirm this issue does not contain any sensitive information.
@sonalsagarwal sonalsagarwal added area/ysql Yugabyte SQL (YSQL) status/awaiting-triage Issue awaiting triage labels Aug 9, 2023
@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue labels Aug 9, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue status/awaiting-triage Issue awaiting triage
Projects
None yet
Milestone
No milestone
Development

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