[postgis-users] Topology: cannot delete slivers (or gaps)

[Sandro Santilli]

On Wed, Nov 19, 2014 at 12:50:09PM +0100, Rémi Cura wrote:
> Hey Sandro,
> in my opinion we don't need a better speed for current construction, we
> need a batch constructing mode !

This is for sure, as the current one just does the intial noding
but finally invokes the incremental functions.

> Optimally it could be done by using the geos, because it constructs all the
> topology very very fast.

Possibly, yes.
Then I guess attributes association would be left to a second step...

> Adding one feature is actually quite fast, even on already big topology.
> 
> Its when you want to add a lot's that it becomes increasingly slow (maybe
> because indexes are not updated,or because we are in one transaction?)
> The slowing seems to be very non linear, probably following n^2, where n is
> the number of feature already constructed in the transaction.

An issue with index use was recently fixed.
There might be another one hiding somewhere.

--strk;