[postgis-tickets] [PostGIS] #2993: Reduce updates on topology building

PostGIS trac at osgeo.org
Mon Nov 17 04:35:16 PST 2014


#2993: Reduce updates on topology building
-------------------------+--------------------------------------------------
 Reporter:  strk         |       Owner:  strk          
     Type:  enhancement  |      Status:  new           
 Priority:  medium       |   Milestone:  PostGIS Future
Component:  topology     |     Version:  trunk         
 Keywords:               |  
-------------------------+--------------------------------------------------
 Measuring operations of TopoGeo_addPolygon I saw that each call results in
 one INSERT and 2 UPDATEs for each node (1 node per polygon) and an INSERT
 and an UPDATE for each edge (1 edge in absence of intersection or more).

 This ticket is to study the problem and search for a reduction of UPDATES,
 which in the case of edges are also never HOT, thus resulting in edge
 indexes having twice as many rows as the actual source table.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2993>
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-tickets mailing list