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

[PostGIS]

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

Comment(by pracine):

 I just tested again:

 SELECT x, y FROM generate_series(1, 10) x, generate_series(1, 10) y,
 srtm_35_04_10x10

 and the memory doesn't grow...

 SELECT version() gives:

 "PostgreSQL 8.4.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.5
 (mingw-vista special r3), 32-bit"

 SELECT postgis_version() gives:

 "2.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"

 SELECT postgis_lib_version() gives:

 "2.0.0SVN"

 SELECT postgis_raster_lib_version() gives:

 "2.0.0SVN"

 It seems very strange to me that:

 SELECT x, y FROM generate_series(1, 10) x, generate_series(1, 10) y,
 srtm_35_04_10x10;

 makes the backend memory to grow. I can understand that the client grow
 because it is receiving many rows but the backend should behave smoothly
 (isn't that the strenght of PostgreSQL?).

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