Opened 13 years ago

Closed 8 years ago

Last modified 7 years ago

#1507 closed enhancement (wontfix)

Performance improvement: reduce savepoints in function

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS Fund Me
Component: topology Version: master
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 (6)

comment:2 by strk, 13 years ago

Milestone: PostGIS 2.0.0PostGIS 2.1.0

Enhancements, later

comment:3 by robe, 12 years ago

Milestone: PostGIS 2.1.0PostGIS 2.2.0

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

comment:4 by strk, 10 years ago

Milestone: PostGIS 2.2.0PostGIS Future

comment:5 by strk, 8 years ago

Resolution: wontfix
Status: newclosed

Closing as deprecated now that most topology is done in C rather than plpgsql (I don't think we're using savepoints there).

comment:6 by robe, 7 years ago

Milestone: PostGIS FuturePostGIS Fund Me

Milestone renamed

Note: See TracTickets for help on using tickets.