[postgis-users] multipolygon polygon test intersects

[Christo Du Preez]

I didn't think I can create a GIST index on a temp table withing a
function...

Thanx for the thought, I will try it

Nicolas Ribot wrote:
>> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>

-- 
Christo Du Preez

Senior Software Engineer
Mecola IT
Mobile:	 +27 [0]83 326 8087
Skype:	 christodupreez
Website: http://www.locateandtrade.co.za