how long should it take for this query to run?
Opened this issue · 2 comments
simonkassel commented
I'm running the second query and it's up to 45 minutes. How long is it taking for everyone else?
galkamax commented
@simonkassel There is a trick for speeding it up. If you add a WHERE clause like this, it will only bother calculating the distance for points that are nearby.
WHERE ST_Distance(r.geom, a.geom) < 0.01
It's the spatial index that allows this to work.
simonkassel commented
This was a gamechanger. thanks