~/talk

Spark, Dask, DuckDB, and Polars: Benchmarks

Talkat PyData NYC 2023 · 2023-11-01..11-03· [databases]
slides:none on file

Benchmarks run Spark, Dask, DuckDB and Polars on scales from 10 GiB to 10 TiB using TPC-H on a local M1 MacBook Pro and AWS instances, with orchestration via Coiled. Key findings: no tool wins consistently; DuckDB performs admirably across many scales and sustains ~1–2 GB/s S3 reads on a big node, Dask completes all queries across scales by aggregating bandwidth (peaking near 7 GB/s), Polars is lightning fast on single machines but struggles at large scale, and Spark often needs careful tuning and fails to finish 10 TiB runs under an hour. S3 bandwidth is the dominant bottleneck (per-node ~50–200 MB/s).

AI-written summary · about

  1. 0:00Introduction
  2. 1:31Why compare these systems
  3. 5:28TPC-H overview
  4. 7:12Avoiding benchmark bias
  5. 10:24Local 10GB results
  6. 11:49Cloud 10GB results
  7. 12:53Scaling to 100GB and 1TB
  8. 13:35Analyzing results
  9. 16:23Cloud bottlenecks
  10. 18:09Inter-machine communication costs
  11. 21:02DuckDB performance
  12. 21:45Coiled scaling
  13. 25:22Spark on Coiled
  14. 26:47Dask roadmap
  15. 27:33Q&A
  16. 27:55S3 networking
  17. 29:40Dask goals
  18. 31:06New data types
  19. 32:29Data warehouse comparison
  20. 33:55Hardware relevance
  21. 34:58Arrow S3 improvements
  22. 36:01Closing thoughts
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.