[postgis-devel] ST_Value out of memory

[Mateusz Loskot]

On 18/01/11 18:32, Etienne Bellemare wrote:
> It is a good solution. I modified it to only query the rasters
> intersecting the extent of my points,  but bottom line, by reducing the
> number of rasters, it works. And it's not taking longer.
> Do you think that the memory problem is coming from st_value() loading
> all the intersecting tiles in memory ?

I haven't debugged it myself, but I would expect memory fragmentation 
problem. Your original query potentially leads to sequence of huge
number of significant-size allocations and deallocations.

The fact that you have 3GB and PostgreSQL is giving up using less than 
2GB suggests fragmentation problem.

You can not do much about it.

Best regards,
-- 
Mateusz Loskot, http://mateusz.loskot.net
Charter Member of OSGeo, http://osgeo.org
Member of ACCU, http://accu.org