search

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
https://www.yugabyte.com
Other
8.9k stars 1.06k forks source link

[ysql] Different plan chosen by CBO when fast backward scans is enabled, leading to performance degradation #23402

Open yugabyte-ci opened 1 month ago

yugabyte-ci commented 1 month ago

Jira Link: DB-12320

Different plan chosen by CBO when fast backward scans is enabled, leading to performance degradation.

Details

From the report - https://taqo.dev.yugabyte.com/regression/33 (fast backward scan feature enabled in CBO), query 59ebf1c77e58cb2291c35486e2f96137 shows a regression.

rthallamko3 commented 1 month ago

More details in the commit https://github.com/yugabyte/yugabyte-db/commit/0c664a14176427d39020a567fbaaf496a221f0f3

Screenshot 2024-08-07 at 4 45 31 PM