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] Query latency increased on upgrade from 2.4.4 to 2.8.3 #11841

Closed
dataindataout opened this issue Mar 22, 2022 · 1 comment
Closed

[YSQL] Query latency increased on upgrade from 2.4.4 to 2.8.3 #11841

dataindataout opened this issue Mar 22, 2022 · 1 comment
Assignees
@tanujnay112
Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug priority/medium Medium priority issue

Comments

@dataindataout
Copy link
Contributor

dataindataout commented Mar 22, 2022 •
edited by yugabyte-ci
Loading

Jira Link: DB-713

Description

Query latency increased on upgrade from 2.4.4 to 2.8.3.

Query involved joining two tables, with otherwise normal characteristics. On 2.4.4, the query used an index scan; post-upgrade to 2.8.3, the query used only a sequential scan.

Refer to internal ticket for specifics.
@dataindataout dataindataout added the area/ysql Yugabyte SQL (YSQL) label Mar 22, 2022
@CharlotteRose
Copy link
Contributor

@dataindataout @sushantrmishra - is this still an issue? Do we need a JIRA for this?

@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jun 8, 2022
@ryan-ally ryan-ally mentioned this issue Nov 30, 2023
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@tanujnay112 tanujnay112

Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug priority/medium Medium priority issue
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@tanujnay112 @CharlotteRose @dataindataout @yugabyte-ci