cloudberry
cloudberry copied to clipboard
Push the runtime filter to table am.
- Give explain analyze runtime info.
- Add pushdown runtime qual to table access method.
- Introduce
gp_runtime_filter_selectivity_thresholdto handle bad case. - 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
- [ ] Followed contribution guide
- [ ] Added/updated documentation
- [ ] Reviewed code for security implications
- [ ] Requested review from cloudberry committers