how long should it take for this query to run?

[simonkassel]

I'm running the second query and it's up to 45 minutes. How long is it taking for everyone else?

[galkamax]

@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]

This was a gamechanger. thanks