[postgis-users] topology performance improvement purpose

[Sandro Santilli]

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