[postgis-users] Memory problem with ST_Within

[Mark Cave-Ayland]

Birgit Laggner wrote:

> Hallo Mark,
> 
> this is my postgis version:
> 
> "POSTGIS="1.3.3" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.6.0, 21 Dec 2007" 
> USE_STATS"
> 
> The memory usage information of the PostgreSQL log file, I attached to 
> the e-mail (pg.log).
> 
> Thank you!

Hi Birgit,

Thanks for the information from the log file. It's definitely a memory 
leak somewhere, as you see this:

ExecutorState: 10456410616 total in 1258 blocks; 22672 free (7 chunks); 
10456387944 used

How big is your dataset? Is it something that you could compress and 
email a link off-list so we could look into this?

Paul/Mateusz: Could this have been resolved by some of the recent memory 
fixes in GEOS SVN?


ATB,

Mark.

-- 
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063