[postgis-devel] optimized predicates

[Martin Davis]

Are we correct in thinking that GEOS 3.1 uses the PreparedGeometry 
predicates to implement ST_Contains and ST_Intersects?

If so, perhaps it would be better to revert to the original 
implementation for these predicates, and provide different function 
names for the Prepared versions, until this problem is fixed?

Kevin Neufeld wrote:
> Hi folks, there seems to be a significant memory leak issue with 
> ST_Contains() and ST_Intersects().
>
> I'm trying to do a simple point-in-polygon join using ~800 points and 
> ~250000 polygons.
>
> Running PG8.3.3, PGIS1.3.3, and GEOS="3.1.0-CAPI-1.5.0", the query 
> spikes up to 3GB of RAM before completing in 20seconds.
>
> Running PG8.2.0, PGIS1.1.6, the query uses a nominal amount of memory 
> (indeterminable looking at top), and also runs in 20secs.
>
> -- Kevin
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>

-- 
Martin Davis
Senior Technical Architect
Refractions Research, Inc.
(250) 383-3022