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

[PostGIS]

#2993: Reduce updates on topology building
-------------------------+--------------------------------------------------
 Reporter:  strk         |       Owner:  strk          
     Type:  enhancement  |      Status:  new           
 Priority:  medium       |   Milestone:  PostGIS Future
Component:  topology     |     Version:  trunk         
 Keywords:               |  
-------------------------+--------------------------------------------------

Comment(by strk):

 To check for the number of operations performed on the edge_table after
 converting simple geometries, here's a useful query:
 {{{
 select * from pg_stat_all_tables where relname = 'edge_data' and
 schemaname = :toponame;
 }}}

 From #2998 I see that converting 99 simple geometries can result in 175
 inserts and 365 updates on the table (two updates for each insert + a
 spare 15 more). Additionally, 417 sequencial scans and 3428 index scans
 are performed (ugh).

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