[postgis-users] a long time calculate distance between point and polygon

[Francisco Salas]

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>