Ticket #1507 (new enhancement)

Opened 16 months ago

Last modified 2 weeks ago

Performance improvement: reduce savepoints in function

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 2.2.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 16 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 15 months ago by strk

  • milestone changed from PostGIS 2.0.0 to PostGIS 2.1.0

Enhancements, later

Changed 2 weeks ago by robe

  • milestone changed from PostGIS 2.1.0 to PostGIS 2.2.0

later. Push back if you think you can get to it by next week.

Note: See TracTickets for help on using tickets.