[postgis-users] Postgis 2.0 Topology TopoGeo_AddPolygon very slow

[Rémi Cura]

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 <christophevergon-girtec at orange.fr>

> 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
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>>
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140113/9cb73cbc/attachment.html>