Max Gabrielsson

Yeah the buffering does probably add quite a bit of overhead, butI mean, in essence you are comparing everything to everything, you're going to end up with a result doing...

I don't know exactly what PostGIS does to make it that much faster... is the table indexed? I guess it would be possible to create a temporary r-tree index to...

Ok, the Postgres query plan seems to be basically equivalent to ours, here ive created a table with 100k rows of random ids and points. ``` CREATE TABLE t2 AS...

Alright, so I've been working quite a lot on optimizing `ST_Distance` and `ST_DWithin` As of DuckDB v1.3.1 (soon to be released), the following query: ```sql CREATE TABLE t2 AS SELECT...

Hello! GPKG isn't really a cloud-optimized format, meaning a reader had to do a lot of random small range requests and "jump around" when scanning a gpkg file remotely. You...

Hi! Happy to hear DuckDB spatial is useful for you and thanks for opening this issue! R-Tree indexes are not used for spatial joins yet, only when doing spatial filters,...

Hello! Thanks for opening this issue! ST_Intersection is handled by the GEOS library, so I dont think there is much we can do here... what version of QGIS are you...

How did you create the QGIS intersection points? Did you reproject in QGIS as well? I can't even get DuckDB to produce the same intersections you show given your data,...

I tried reproducing this in PostGIS, and I get the exact same result as DuckDB, down to the last decimal. So `ST_Intersection` is not the issue. ```sql create temp table...

Alright, but if I import the data straight into postgis first, and then run the intersection I get your results. So presumably something is wrong in the reprojection step. ```bash...