[postgis-devel] new "verbose" argument in postgis topology function

[Sandro Santilli]

On Fri, Nov 22, 2013 at 03:52:15PM +0100, Rémi Cura wrote:
> Hey Sandro,
> 
> I tried on small amount of topogeometry , using the totopogeom function
> (I use a modified version which doesn't abort when there is a problem with
> one topogeometry)
> 
> The data I insert is the road network near Paris (real data)
> 
> I tried normal , with message to warning, and commenting the raise notice
> 
> It certainly speed it,
> but very few :-/
> (I would say around 5%, at best)
> 
> Alas it is not what slow the topogeom making !

I suspected that :)
There's a postgresql extension that dumps info for statements
taking above a configured amount of milliseconds, you may
want to try playing with it, for somewhat better profiling.

--strk;