Ticket #851 (closed defect: fixed)
[raster] Numerous ST_Value query cause the memory to grow indefinitely
|Reported by:||pracine||Owned by:||jorgearevalo|
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.