Topic
Performance
3 posts from the Query.Farm blog tagged Performance.
DuckDB
Call an API From Every Row in DuckDB, Without the Loop
A table function turns an API call into rows in your database. A LATERAL join lets every row on the left call it — and VGI makes those calls in batches.
23 min read
DuckDB
DuckDB 2.0 Pushes Whole Queries Through ADBC—10–11× Faster on PostgreSQL
Query Farm's adbc_scanner uses DuckDB 2.0 whole-query pushdown to run supported queries entirely in PostgreSQL. In our benchmark, it was 10–11× faster.
16 min read
Distribution
Building DuckDB's Community Extensions, Faster and More Consistently
Every DuckDB engine release needs its community extensions rebuilt before they install. With data from 1,400+ PRs and a full-catalogue rebuild, we make the case for treating the catalogue as a distribution — and show Haybarn rebuilds it ~2.4× faster.
22 min read