[postgis-users] out of memory for query result

[Sandro Santilli]

On Mon, Dec 10, 2012 at 10:08:29AM -0500, Francisco Salas wrote:

> 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

There was a memory leak fixed in the cache handling code.
Are you using the latest 1.5 release ? That's 1.5.8 now.

--strk;