~/talk

Advanced Polars: Lazy Queries and Streaming Mode

Talkat PyData Paris 2025 · 2025-09-30..10-01· [python, web-performance]
slides:none on file

Polars claims Rust-level speed and Apache Arrow memory layout to run lazy queries that optimize across steps using predicate and projection pushdown and expression simplification, letting a scan + collect handle 54 million+ rows without materializing intermediates. LazyFrames represent the query DAG, optimizers reorder and cache subqueries, and a streaming mode processes data in chunks (configurable chunk size) with engine="streaming" but silently falls back if ops like global sort or cumulative sums force in-memory execution.

AI-written summary · about

  1. 0:00Polars beyond generative AI
  2. 3:39Eager mode limitations
  3. 8:16Low-level optimizations
  4. 11:50Lazy query optimization
  5. 16:34Automatic optimizations
  6. 19:46Streaming large datasets
  7. 25:51About the speaker and resources
~/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.