PostGis Topology performance improvements

[remic]

this is a ticket to track much needed postgis topology performance improvements.

Here are some of the already done improvements, along with estimated gained time factor : ​http://lists.osgeo.org/pipermail/postgis-tickets/2014-January/003402.html : x3 ​http://lists.osgeo.org/pipermail/postgis-tickets/2014-January/003422.html : x2

Here are ideas to better accelerate stuff: _index on node.containing_face (could accelerate intersects, addface ,ST_RemEdgeNewFace, ST_RemEdgeModFace,_ST_AddFaceSplit) _batch load mode with disabled check

[strk]

It would be better to have different tickets for different specific improvements. Easier to act on.

[strk]

Mailing list thread about index creation is here: ​http://lists.osgeo.org/pipermail/postgis-devel/2014-July/024410.html

So far there's no evidence of the index improving times of topology building, but rather the contrary (for the creation of topology from simple polygons, and no isolated nodes).

[strk]

Index on node.containing_face is covered by #2861, non-checked (batch) load is covered by #2862 I'm closing this out.