Ticket #1841 (closed enhancement: invalid)
ST_Distance on PostGIS 2.0 is prohibitively slow
|Reported by:||andrewxhill||Owned by:||pramsey|
Running a query to get a pairwise distance calculation for a table takes very long. I'm using this to generate a distance matrix for use in R.
An example query,
select a.a as g1, b.a as g2, st_distance(a.g, b.g) as d from a join a b on a.a<b.a
Can take minutes on the following data,
st_distance - no spheroids 623 polygons with an average of 625 points each (single ring, shell only)