Ticket #1507 (new enhancement)
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
Note: See
TracTickets for help on using
tickets.
