[postgis-users] PostGIS Contains / Intersects / Within Performance

[Paul Ramsey]

I'd love to see some people here with large data volumes who do  
contains/intersects/within tests do some testing of the new postgis/ 
geos prepared geometry code...

To test the new functions

- install the svn snapshot of GEOS
- install the svn snapshot of PostGIS
- use the ST_ContainsPrepared(g1,g2) predicate for the testing

We've seen performance improvements of between 5 and 100 times  
faster.  The bigger and more complicated your test geometries are,  
the faster it should be.

Thanks,

P.