Skip to content

fast-path should support column projection pushdown #52592

Closed
@dbsid

Description

Feature Request

Is your feature request related to a problem? Please describe:

The fast-path point get in TiDB fetch the whole row from TiKV. There is no column projection pushdown for fast-path Get request as Cop result. This can cause performance degradation in below scenarios are:

  1. Wide tables with many columns, where applications only query a few columns.
  2. JSON fields with large column values, where queries may not necessarily retrieve the values of JSON columns or only extract specific small JSON content.

Describe the feature you'd like:

fast-path point get should support column projection pushdown to TiKV, to reduce the GRPC response message size from TiKV and improve the performance, as well as the resource utilization.
Tn addition, the optimizer need to be aware it's worth to do column projection base on the statistics.

Describe alternatives you've considered:

none

Teachability, Documentation, Adoption, Migration Strategy:

performance enhancement.

Activity

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

Metadata

Assignees

No one assigned

    Labels

    type/feature-requestCategorizes issue or PR as related to a new feature.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions