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

planner: support auto-eviction for plan-cache #38593

Open
qw4990 opened this issue Oct 21, 2022 · 1 comment
Open

planner: support auto-eviction for plan-cache #38593

qw4990 opened this issue Oct 21, 2022 · 1 comment
Assignees
@qw4990
Labels
epic/plan-cache sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.

Comments

@qw4990
Copy link
Contributor

qw4990 commented Oct 21, 2022

Enhancement

The current plan cache has risks that may cache some bad plans(e.g. #38533), to alleviate this problem, we can introduce some auto-eviction rules.
For example, introduce a time threshold and let the optimize evict a plan if its execution time exceeds that threshold.
@qw4990 qw4990 added type/enhancement The issue or PR belongs to an enhancement. sig/planner SIG: Planner epic/plan-cache labels Oct 21, 2022
@qw4990 qw4990 self-assigned this Oct 21, 2022
@time-and-fate
Copy link
Member

time-and-fate commented Oct 21, 2022 •
edited
Loading

We could also add a behavior: only cache a plan if its execution time is within the threshold.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@qw4990 qw4990

Labels
epic/plan-cache sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@qw4990 @time-and-fate