Opened 11 years ago
Closed 11 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 by , 11 years ago
| Keywords: | history performance added |
|---|---|
| Milestone: | PostGIS 2.1.2 → PostGIS 2.0.5 |
| Resolution: | → fixed |
| Status: | new → closed |
| Version: | 2.1.x → 2.0.x |
Note:
See TracTickets
for help on using tickets.
r12182 in 2.0 branch (2.0.5), r12183 in 2.1 branch (2.1.2), r12184 in trunk (2.2.0)