[postgis-devel] [PostGIS] #2085: Review performance of TopoGeometry layer constraints

PostGIS trac at osgeo.org
Tue Nov 6 09:59:06 PST 2012

#2085: Review performance of TopoGeometry layer constraints
 Reporter:  strk      |       Owner:  strk         
     Type:  defect    |      Status:  new          
 Priority:  medium    |   Milestone:  PostGIS 2.0.2
Component:  topology  |     Version:  2.0.x        
 Keywords:            |  
 I just realized how slow it is to add TopoGeometry objects in a
 TopoGeometry layer compared with updating any other field.

 I'm talking about 2/3 minutes versus subsecond time to set a text field
 for a table with less than 4000 rows.

 So I guess the layer CHECK constraints are slowing things down.

 This ticket is to review that and see if it can be improved.
 If it cannot, at least document what a good workaround is before running
 the `UPDATE ... SET topogeom = toTopoGeom` mantra

Ticket URL: <http://trac.osgeo.org/postgis/ticket/2085>
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