Skip to content

Always push down Agg when est-row is less than a specific variable #38874

@qw4990

Description

@qw4990

Enhancement

Same as #26089.

Currently, in the planner, the choice between push down Agg or not is cost-based. But sometimes the cost calculation is not accurate enough to make the correct choice. When we choose not to push down Agg when it should, the SQL execution will become very slow sometimes. Considering the risk and benefit, always choose to push down the Agg may be a better strategy.

Metadata

Metadata

Assignees

Labels

sig/plannerSIG: Plannertype/enhancementThe issue or PR belongs to an enhancement.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions