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

PostGIS trac at osgeo.org
Fri Mar 4 13:29:57 PST 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:                  |  
----------------------------+-----------------------------------------------
 A query like this:

 SELECT ST_Value(rast, 1, x, y)
 FROM generate_series(1, 10) x, generate_series(1, 10) y,
 srtm_22_03_tiled_10x10

 causes the memory to grow indefinitely finally returning an error. There
 seems to be a memory leek somewhere. I am wondering if we should not use
 PG_FREE_IF_COPY(pgraster,0) in rt_pg.c

 Also: Smaller the tiles, faster the memory grows. But I think this is only
 related to the page size. Equivalent area splitted in small tiles just
 loads faster.

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