help wantedsig/executiontype/enhancement
仓库指标
- Star
- (40,090 star)
- PR 合并指标
- (平均合并 14天 4小时) (30 天内合并 346 个 PR)
描述
Feature Request
Is your feature request related to a problem? Please describe:
Now the implementation of TiDB's hash-join executor is rough and after profiling, we found there are some issues can be resolved to get better performance:

- not necessary to initialize and reset the
baseJoiner.chkif no condition #14902 - the method
joinMatchedProbeSideRow2Chunkuses the methodNewIterator4Sliceto create a lot of iterators whereas these iterators can be reused. #15423 - some slices created in
GetMatchRowsAndPtrscan be reused. #15423 - we can try to change the return type of
entryStore.getfrom structs to pointers which may reduce memory copy(but it may cause some GC problems so we need some tests after update). - we can try to build the hash table in parallel.
If you have any other ideas, welcome to discuss it with us in our SIG-Exec channel or in this issue by using comments.