Opened 10 years ago

Closed 10 years ago

#2610 closed defect (fixed)

ST_AddEdge* fails to use index on edge table on face split

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 2.0.5
Component: topology Version: 2.0.x
Keywords: history, performance Cc:


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

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

Change History (1)

comment:1 by strk, 10 years ago

Keywords: history performance added
Milestone: PostGIS 2.1.2PostGIS 2.0.5
Resolution: fixed
Status: newclosed
Version: 2.1.x2.0.x

r12182 in 2.0 branch (2.0.5), r12183 in 2.1 branch (2.1.2), r12184 in trunk (2.2.0)

Note: See TracTickets for help on using tickets.