[postgis-devel] [PostGIS] #837: ST_MapAlgebra -- I think we have a memory leak

[PostGIS]

#837: ST_MapAlgebra -- I think we have a memory leak
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------
Description changed by robe:

Old description:

> I tried to do this on my test elephant
>  -- its a single tile -- I forget the size
>
> {{{
> UPDATE ch13.pele SET map_rast = ST_MapAlgebra(rast,'CASE WHEN rast
> BETWEEN 100 and 250 THEN 1 WHEN rast = 252 THEN 2 WHEN rast BETWEEN 253
> and 254 THEN 3 ELSE 0 END', '2BUI') ;
> }}}
>

> and it crashes the server after about 13 seconds.
>
> This is on Windows XP latest trunk.

New description:

 I tried to do this on my test elephant
  -- its a single tile -- I forget the size
  O
 {{{
 ALTER TABLE ch13.pele ADD column map_rast raster;
 UPDATE ch13.pele
 SET map_rast = ST_MapAlgebra(rast,'CASE WHEN rast BETWEEN 100 and 250 THEN
 1 WHEN rast = 252 THEN 2 WHEN rast BETWEEN 253 and 254 THEN 3 ELSE 0 END',
 '2BUI') ;
 }}}


 and it crashes the server after about 13 seconds.

 This is on Windows XP latest trunk.

--

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/837#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.