Ticket #1507 (new enhancement)

Opened 4 months ago

Last modified 3 months ago

Performance improvement: reduce savepoints in function

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 2.1.0
Component: topology Version: trunk
Keywords: Cc:

Description

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

Change History

Changed 4 months ago by strk

Reference about error trapping being "significantly more expensive":  http://www.postgresql.org/docs/8.4/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING

Changed 3 months ago by strk

  • milestone changed from PostGIS 2.0.0 to PostGIS 2.1.0

Enhancements, later

Note: See TracTickets for help on using tickets.