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

Support cache the plan with limit ? #38491

Closed
Reminiscent opened this issue Oct 17, 2022 · 1 comment
Closed

Support cache the plan with limit ? #38491

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

Comments

@Reminiscent
Copy link
Contributor

Enhancement

Now, the prepare statement with limit ? can not be cached. Because different numbers for limit may need the different best plan.But in some scenario, the number for the limit may be close. We should support a variable to control whether we can cache the statement with limit ? or not.
@Reminiscent Reminiscent added type/enhancement The issue or PR belongs to an enhancement. sig/planner SIG: Planner epic/plan-cache labels Oct 17, 2022
@tisonkun tisonkun mentioned this issue Nov 16, 2022
Merged
@qw4990 qw4990 mentioned this issue Jan 4, 2023
Closed
@qw4990
Copy link
Contributor

qw4990 commented Jan 4, 2023

Duplicated with #40219

@qw4990 qw4990 closed this as completed Jan 4, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
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 @Reminiscent