[postgis-users] topology performance improvement purpose

[Jose Carlos Martinez Llario]

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