Improve DataFusion scalability as more cores are added #5999
Description
Is your feature request related to a problem or challenge?
I ran some benchmarks in constrained Docker containers and found that DataFusion is pretty close to DuckDB speed when running on a single core but does not scale as well as DuckDB when more cores are added.
At 16 cores, DuckDB was ~2.9x faster than DataFusion for this particular test.
| Cores | DuckDB 0.7.1 | DataFusion Python 21.0.0 | DuckDB x Faster |
|---|---|---|---|
| 1 | 315,630.9 | 318,037.8 | 1.0 |
| 2 | 155,034.5 | 197,257.3 | 1.3 |
| 4 | 75,110.0 | 111,243.1 | 1.5 |
| 8 | 37,584.9 | 73,142.3 | 1.9 |
| 16 | 18,880.3 | 55,071.8 | 2.9 |
Describe the solution you'd like
I would like DataFusion to scale as well as DuckDB as more cores are added.
Describe alternatives you've considered
No response
Additional context
Instructions for creating the Docker images can be found at https://github.com/sql-benchmarks/sqlbench-runners