>Hallo > >First your question about index-handling of multi-geometries. >The index handles the whole geometry as one big so in your case where >the multi-parts are spread you will get a lot better performance if you >use st_dump to split the multi to several rows of single polygons and >build an index on that.
Hi, That work very well. Always do index on the dumped version of geometries Now the query time is down to few minutes. :)) Dumping the geometry in single parts is definitively better for index. Now I do some tests, as you suggest, to reduce the number of unknown. -- ----------------- Andrea Peri . . . . . . . . . qwerty àèìòù -----------------
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
