[postgis-tickets] [PostGIS] #3000: Edge linking does not use index

PostGIS trac at osgeo.org
Tue Dec 30 12:37:46 PST 2014


#3000: Edge linking does not use index
--------------------------+-------------------------------------------------
  Reporter:  strk         |       Owner:  strk         
      Type:  enhancement  |      Status:  closed       
  Priority:  medium       |   Milestone:  PostGIS 2.2.0
 Component:  topology     |     Version:  trunk        
Resolution:  fixed        |    Keywords:  performance  
--------------------------+-------------------------------------------------

Comment(by bjornharrtell):

 For posteriority - Preliminary results show that I get similar speedup
 with this patch as with additional indexes on edge_data (which are
 undesirable).

 Screenshot of a time profile of the statements run at loading ~12000
 unclean polygon into a new topology (run with r13167):
 [[Image(https://cloud.githubusercontent.com/assets/141030/5582520/2759ed00
 -906b-11e4-89c6-48e00ebb30e3.png)]]

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/3000#comment:6>
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.


More information about the postgis-tickets mailing list