[postgis-devel] [PostGIS] #851: [raster] Numerous ST_Value query cause the memory to grow indefinitely

PostGIS trac at osgeo.org
Tue Mar 15 09:30:15 PDT 2011


#851: [raster] Numerous ST_Value query cause the memory to grow indefinitely
----------------------------+-----------------------------------------------
 Reporter:  pracine         |       Owner:  pracine      
     Type:  defect          |      Status:  new          
 Priority:  critical        |   Milestone:  PostGIS 2.0.0
Component:  postgis raster  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by pracine):

 No memory growing? Nothing? What if you test on a coverage composed of
 smaller tiles (10x10)? The memory should grow faster and higher.

 This memory growth might be acceptable on one srtm raster but it overflows
 on a coverage composed of many of those.

 This symptom is generalised to most functions. It is worst with ST_Value
 because when iterating over a raster you call it millions of time but the
 same problem would show up with most function if there are millions of
 tiles.

 I am pretty sure this is the same problem Etienne encountered here:

 http://postgis.refractions.net/pipermail/postgis-
 devel/2011-January/011505.html

 The test I did was to simplify RASTER_getPixelValue to the point where it
 just returns a constant, no ctx, nada and in this case there is no general
 memory growth. Every function should release any memory allocated and the
 memory use should be almost constant without growing constantly.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/851#comment:11>
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.


More information about the postgis-devel mailing list