Skip to content

planner: treat plans with different in-list length as the same one in plan cache #42984

Open
@qw4990

Description

Enhancement

Currently, for 2 'same' queries with different in-list lengths, plan cache will generate and cache different plans for them.
For example, plan cache will cache 2 plans for the 2 'same' queries below:
select * from t where a in (1, 2), select * from t where a in (1, 2, 3).

This strategy can cause lots of memory usage:
image

Activity

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

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions