[postgis-devel] [PostGIS] #806: Optimize Geometry(TopoGeometry) for polygons

PostGIS trac at osgeo.org
Tue Feb 15 00:39:12 PST 2011


#806: Optimize Geometry(TopoGeometry) for polygons
--------------------------+-------------------------------------------------
  Reporter:  strk         |       Owner:  strk         
      Type:  enhancement  |      Status:  closed       
  Priority:  medium       |   Milestone:  PostGIS 2.0.0
 Component:  topology     |     Version:  trunk        
Resolution:  fixed        |    Keywords:               
--------------------------+-------------------------------------------------
Changes (by strk):

  * status:  new => closed
  * resolution:  => fixed


Comment:

 So, at a closer look it turned out the bottleneck was on fetching edges
 composing faces rather than polygonizing them.
 Creating indexes on "left_face" and "right_face" speeded things up by a
 factor of 10.
 r6822 adds index creation to CreateTopology.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/806#comment:1>
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