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 > [email protected] > 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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
