[postgis-users] multipolygon polygon test intersects

[Nicolas Ribot]

> 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.

Nicolas