[postgis-users] multipolygon polygon test intersects
nicky666 at gmail.com
Mon May 28 08:16:06 PDT 2007
> I managed to get it working. The only problem is speed.
> I'm using it in a function and having to test a couple thousand polygons
> takes ages. I also tried using a temp table, this is also not an option
> because of the speed issue.
have-you created GiST index on the temp table you are using ?
It should greatly improve the performance.
postgis, when using the && operator, uses spatial index to reduce the
list of candidates to evaluate.
More information about the postgis-users