It's not 'topology', but the actual name of the topology. Each topology has data in its own schema...
--strk; On Wed, May 09, 2012 at 09:11:54AM +0800, Ben Madin wrote: > Do you need to even change the search_path - surely you could have a function > version with the 'topology' schema hard-coded for the performance > improvement. Obviously that won't work if you have a different schema name, > but if the performance enhancement is worth it, grepping out topology to > whatever you need will also be worth the effort. > > cheers > > Ben > > > On 03/05/2012, at 5:58 AM, Jose Carlos Martinez Llario wrote: > > > Hi, > > wanted to share a though about improving the topology performance in > > postgis. > > > > Many of the functions are using EXECUTE instead of running directly select > > commands. > > In many cases this is need just because of the used of the schema name of > > the topology primitive tables. > > > > I found between 4 and 10 times improving performance some sentences. I > > guessing it could be even better. > > > > My question is if an approach like the following makes sense: > > > > 1.- With one command we can make the current topology schema the default > > schema in search path, > > 2.- then working with topology > > 3.- Change search_path again when finishing the spatial analysis. > > > > (the parameter of the topology name in the functions should be ignored or > > removed) > > I know it requires a lot of changes but currently the performance of the > > persistent topology is too slow. > > > > if one do that many functions can be run without EXECUTE. Spatial analysis > > between different topologies is not possible which fits the procedure. > > > > What do you think Sandro? > > > > Regards, > > Jose > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users -- ,------o-. | __/ | Delivering high quality PostGIS 2.0 ! | / 2.0 | http://strk.keybit.net - http://vizzuality.com `-o------' _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
