Post
Malcolm Meyer
malcolmmeyer.com
did:plc:s5snraztreagsczue7vummna
Interesting results from benchmarking #duckdb on large spatial queries - https://www.malcolmmeyer.com/posts/benchmarking-spatial-joins-in-duckdb/
tl;dr - use "WHERE ST_Intersects(g, geom) IS TRUE" IS TRUE being key there - with a bbox filter to get faster results
#gis #geospatial #cloudnative #parquet #osm #openstreetmap #overture
2026-10-20T13:16:40.945Z