TGViewer
Dev Signal Dev Signal @the_dev_signal · 2.18K subscribers
Post #325 63
DuckDB: Speed Up String GROUP BYs With Narrow Dimension Keys

DuckDB explains how to replace repeated string group keys with sorted, narrow integer keys in a dimension table, then join labels back after aggregation. The walkthrough uses a 380,959-row dataset with 537 station names and details string hashing, comparisons, hash-table width, and perfect-hash selection.

🔗 duckdb.org

#DuckDB #SQL #QueryPerformance
Open in Telegram All posts from @the_dev_signal
More from @the_dev_signal
  1. Sep 29, 2026Cloudflare Previews Tokio on Workers Through Emscripten Cloudflare released an experimenta…
  2. Sep 27, 2026DuckDB Queries Hugging Face Datasets In Place with hf:// Paths DuckDB’s hf:// path scheme…
  3. Sep 27, 2026Elasticsearch GPU HNSW indexing cuts 138M-vector build below 10 minutes Elasticsearch desc…
  4. Sep 25, 2026rust-analyzer Adds cfg!() Completions and Trait-Solver Panic Fixes rust-analyzer’s Septemb…
  5. Sep 20, 2026Five Million Rows Show Where SQLite and DuckDB Split A reproducible five-million-row compa…
  6. Sep 18, 2026Agentic Inference Turns KV Cache Management Into a Scheduling Problem This deep dive frame…
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook →Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 →