Nicklas, I am working in geometry data type with SRID 4326 , in other mail Sandro ask me what version of postgis I have using. It's possible that using version 1.5 of Postgis? Thanks, Francisco Salas
-----Mensaje original----- De: Nicklas Avén [mailto:[email protected]] Enviado el: martes, 11 de diciembre de 2012 02:59 p.m. Para: Francisco Salas Asunto: RE: [postgis-users] a long time calculate distance between point and polygon Ops, that sounds like something that shouldn't happen. It looks like a server crash. Could you please try to make your data set as small as possible, but still getting that server crash, and share that part of your data set. Are you working in geometry or geography data type? Regards Nicklas On Mon, 2012-12-10 at 09:46 -0500, Francisco Salas wrote: > Hi, Nicklas , I used this > select * from pozos p,suelos s where > ST_DWithin(p.the_geom,s.the_geom,1000) > > but in the output panel Messages of the pgAdmin III , appear only this > around 22011 ms > ********** Error ********** > > How I can determinate what's is the problems ? > > Regards, > Francisco Salas > > -----Mensaje original----- > De: [email protected] > [mailto:[email protected]] En nombre de Nicklas > Avén Enviado el: miércoles, 05 de diciembre de 2012 04:45 p.m. > Para: PostGIS Users Discussion > Asunto: Re: [postgis-users] a long time calculate distance between > point and polygon > > Hallo > > You should use ST_DWithin instead with gist index on your > gometry/geography > column: > > select * from pozos p,suelos s where > ST_DWithin(p.the_geom,s.the_geom,1000) > > > HTH > > Nicklas > > > > On Wed, 2012-12-05 at 16:32 -0500, Francisco Salas wrote: > > 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 > > > > > > > > > > _______________________________________________ > > postgis-users mailing list > > [email protected] > > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
