People answered about finding why postgis_topology is slow : the 2 suggestions were : _http://www.postgresql.org/docs/9.2/static/auto-explain.html _ http://blog.guillaume.lelarge.info/index.php/post/2012/03/31/Profiling-PL/pgsql-functions
First one looks classical and harder Second one contains interesting stuff, maybe sufficient to see where it is slow. Cheers, Rémi-C 2014/1/13 Christophe Vergon <[email protected]> > Thanks, > > We will happy to contribute in any way. I'd read the thread on osgeo list, > a little bit cloudy for me, but I'll expect it to be sunny very soon. > > Christophe > > > Sandro Santilli a écrit : > > On Mon, Jan 13, 2014 at 09:37:56AM +0100, Christophe Vergon wrote: >> >>> Hi, >>> >>> We use TopoGeo_AddPolygon Function to fill our database, it works. >>> Now we've got 500 000 faces, and adding new faces with this function >>> is very slow. >>> At the end our database will contain approximatly 1 million of >>> faces, I stop data integration for the moment beacause it's too >>> slow. >>> >>> Is there a new function version planned ? >>> >> No plans for a new function, but there's some analisys >> undergoing to find more about this exact problem. >> Get on postgis-devel if you want to help with that: >> http://lists.osgeo.org/pipermail/postgis-devel/2014-January/024076.html >> >> --strk; >> >> () ASCII ribbon campaign - against html e-mail >> /\ http://www.asciiribbon.org - against proprietary attachments >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> >> >> > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
