[postgis-users] out of memory for query result

[Francisco Salas]

Hi, I test this sentence 

 

select * from pozos p,manantiales s where
ST_DWithin(p.the_geom,s.wkb_geometry,1000)

 

in pgAdmin III PostgreSQL 9.0 and  Postgis 1.5. 

 

around 63832 ms appear  this error :

out of memory for query result

 

Best regards,

Francisco Salas.

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121210/93c57743/attachment.html>