-
Notifications
You must be signed in to change notification settings - Fork 5.8k
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.
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
planner: allow the optimizer to cache query plans accessing generated columns #45798
Closed
7 tasks done
Labels
epic/plan-cache
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
Comments
qw4990
added
type/enhancement
The issue or PR belongs to an enhancement.
sig/planner
SIG: Planner
epic/plan-cache
labels
Aug 3, 2023
qw4990
changed the title
planner: allow the optimizer to cache some query plans that access generated columns but generated columns not appear in predicates
planner: allow the optimizer to cache some query plans that access generated columns if generated columns not appear in predicates
Aug 3, 2023
qw4990
changed the title
planner: allow the optimizer to cache some query plans that access generated columns if generated columns not appear in predicates
planner: allow the optimizer to cache some query plans accessing generated columns if these generated columns not appear in predicates
Aug 3, 2023
qw4990
changed the title
planner: allow the optimizer to cache some query plans accessing generated columns if these generated columns not appear in predicates
planner: allow the optimizer to cache some query plans accessing generated columns
Aug 3, 2023
qw4990
changed the title
planner: allow the optimizer to cache some query plans accessing generated columns
planner: allow the optimizer to cache query plans accessing generated columns
Aug 3, 2023
Closed
12 tasks
13 tasks
13 tasks
13 tasks
13 tasks
13 tasks
Merged
13 tasks
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Labels
epic/plan-cache
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
Enhancement
Work Item Tracking
index.test
to test Plan Cache + MVIndex planner: add more test cases for plan cache with generated columns #51483multi_valued_index.test
,multi_valued_index.test
to test Plan Cache + MVIndex planner: add more test cases for plan cache with generated columns #51510json_contains/overlaps
lead to uncacheable plans, choose to generate optimal plans without caching rather than caching sub-optimal plans planner: choose to generate optimal plans without plan cache rather than generating suboptimal plans and caching it when generating MVIndex plans #51546Description
Currently, queries below are not allowed to be cached since these queries are accessing generated columns:
The text was updated successfully, but these errors were encountered: