[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