[postgis-devel] [PostGIS] #1806: Extremely slow and CPU-intensive ST_MakeValid (ST_BuildArea) case

PostGIS trac at osgeo.org
Tue May 8 03:59:59 PDT 2012


#1806: Extremely slow and CPU-intensive ST_MakeValid (ST_BuildArea) case
---------------------+------------------------------------------------------
 Reporter:  strk     |       Owner:  strk         
     Type:  defect   |      Status:  assigned     
 Priority:  high     |   Milestone:  PostGIS 2.0.1
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by strk):

 polygonize finds 3536 polygons, so ST_BuildArea is stuck computing the
 symdifference between each of them and the aggregated result. While it
 goes on the time it takes to compute the symdifference grows. It starts
 with roughly 20 items per second. At iteration 1700 computes ~5
 symdifference per second... Every iteration has to rebuild the topology
 which was already built in the previous iteration.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1806#comment:5>
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-devel mailing list