[postgis-users] a long time calculate distance between point and polygon
Francisco Salas
fsalas at pinar.geocuba.cu
Wed Dec 5 13:32:18 PST 2012
Hi,
I have test in two database one with SRID 2085 an other 4326 use this sql
pozos : 2339 rows
suelos:1526 rows
for 2085 :
select * from pozos p,suelos s where st_distance(p.the_geom,s.the_geom)
<=1000
time of result : 3 minutes aprox
for 4326 :
select * from pozos p,suelos s where st_distance(p.the_geom,s.the_geom,true)
<=1000
time of result : not determined
Why happen this problem?
How I can optimize this?
I am using PostGis 1.5.2
Regards,
Francisco Salas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121205/e843c248/attachment.html>
More information about the postgis-users
mailing list