[postgis-users] topology performance improvement purpose

[Jose Carlos Martinez Llario]

i meant not the default schema in search_path but the first topology 
working schema after public.

On 02/05/2012 23:58, 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