[postgis-devel] [PostGIS] #1507: Performance improvement: reduce savepoints in function

[PostGIS]

#1507: Performance improvement: reduce savepoints in function
-------------------------+--------------------------------------------------
 Reporter:  strk         |       Owner:  strk         
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.0.0
Component:  topology     |     Version:  trunk        
 Keywords:               |  
-------------------------+--------------------------------------------------
 It's been reported that savepoints/EXCEPTION (subtransactions) are
 particularly expensive. The topology code make heavy use of them.
 Switching back may give _a_lot_ of performance benefit.

 Quoting from #postgresql:
 {{{
  < andres> (like two orders of magnitude or so)
  < andres> improving subtxn performance is on the roadmap, but one partial
 patch was reverted again (incomplete, broken)
  < andres> It also doesn't scale linearly with multiple subtxn in one txn
 }}}

 ... may need a 2.0.1 milestone

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