Opened 6 years ago

Closed 6 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:

Description

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)

Change History (1)

comment:1 Changed 6 years ago by strk

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.