[postgis-devel] optimized predicates

[Paul Ramsey]

On Thu, Jul 10, 2008 at 1:34 PM, Martin Davis <mbdavis at refractions.net> wrote:
> 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
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>