cloudberry icon indicating copy to clipboard operation
cloudberry copied to clipboard

Push the runtime filter to table am.

Open yjhjstz opened this issue 8 months ago • 0 comments

  1. Give explain analyze runtime info.
  2. Add pushdown runtime qual to table access method.
  3. Introduce gp_runtime_filter_selectivity_threshold to handle bad case.
  4. bugfix

tpcds 20GB

config tpcds benchmark with minmax : https://gist.github.com/yjhjstz/7b7394a9a330fa3167a42b45e20f4527

origin gp_enable_runtime_filter_pushdown with minmax --
0 1
3 3  
2 1  
7 7  
3 2  
1 0  
3 1  
0 1  
3 2  
2 2  
7 4  
0 0  
2 1  
13 12  
1 1  
2 2  
3 2  
1 2  
2 0  
1 0  
5 3  
13 13  
22 21  
6 5  
4 2  
1 1  
3 2  
2 1  
3 2  
1 1  
2 1  
2 2  
2 0  
2 2  
4 2  
3 2  
4 4  
3 4  
13 9  
1 0  
1 0  
1 1  
2 2  
1 0  
1 1  
2 2  
3 3  
3 2  
2 0  
2 3  
6 4  
2 1  
1 1  
3 2  
1 0  
2 1  
3 2  
2 1  
4 3  
2 1  
2 2  
1 1  
2 1  
7 7  
6 5  
1 0  
17 17  
3 2  
2 1  
5 2  
2 1  
12 10  
1 2  
7 6  
4 3  
1 0  
2 1  
9 7  
3 3  
3 1  
1 1  
5 4  
1 0  
1 2  
0 0  
1 2  
3 2  
3 1  
1 2  
2 1  
1 0  
1 1  
0 0  
1 1  
10 10  
2 1  
4 3  
1 0  
2 2  
326 256 21.47%

What does this PR do?

Type of Change

  • [ ] Bug fix (non-breaking change)
  • [ ] New feature (non-breaking change)
  • [ ] Breaking change (fix or feature with breaking changes)
  • [ ] Documentation update

Breaking Changes

Test Plan

  • [ ] Unit tests added/updated
  • [ ] Integration tests added/updated
  • [ ] Passed make installcheck
  • [ ] Passed make -C src/test installcheck-cbdb-parallel

Impact

Performance:

User-facing changes:

Dependencies:

Checklist

Additional Context

CI Skip Instructions


yjhjstz avatar Apr 03 '25 00:04 yjhjstz