[postgis-tickets] [PostGIS] #2610: ST_AddEdge* fails to use index on edge table on face split

PostGIS trac at osgeo.org
Mon Jan 13 13:59:58 PST 2014


#2610: ST_AddEdge* fails to use index on edge table on face split
----------------------+-----------------------------------------------------
 Reporter:  strk      |       Owner:  strk         
     Type:  defect    |      Status:  new          
 Priority:  medium    |   Milestone:  PostGIS 2.1.2
Component:  topology  |     Version:  2.1.x        
 Keywords:            |  
----------------------+-----------------------------------------------------
 The edge table update on face split fails to make use of the edge table
 index by passing the return of ST_LineInterpolatePoint(geom) and a literal
 to ST_Contains.

 As a result, topology population has poor scaling performance.
 See http://lists.osgeo.org/pipermail/postgis-
 devel/2014-January/024076.html

 ... I wonder how could such a defect be put under regression testing ...
 (or we'll need a performance testsuite)

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2610>
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