[postgis-tickets] [PostGIS] #3010: PostGis Topology performance improvements: edge_data indexes

[PostGIS]

#3010: PostGis Topology performance improvements: edge_data indexes
---------------------------+------------------------------------------------
 Reporter:  bjornharrtell  |       Owner:  strk 
     Type:  enhancement    |      Status:  new  
 Priority:  medium         |   Milestone:       
Component:  topology       |     Version:  2.1.x
 Keywords:                 |  
---------------------------+------------------------------------------------

Comment(by bjornharrtell):

 Added some diagrams plotting time to load, per polygon, one million
 polygons into a topology. The whole process of loading ~1,3 million
 polygons took ~24h. This is after adding the indexes as described in this
 ticket, without the indexes I gave up loading this many polygons.

 Diagrams are named after max milliseconds displayed. Some funny patterns
 emerge when looking at max 6000 or 300 ms which I think is related to my
 input data. The max 50 ms diagram shows a logarithmic trend line clearly.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/3010#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.