EG 2.11 Merging records will time out with large amounts of holds
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
SIPServer |
Invalid
|
Undecided
|
Unassigned |
Bug Description
EG 2.11
It turns out that the trigger:
reporter_
which fires when action.hold_request rows are updated, will take a long time to update the corresponding target in reporter.
explain analyze update reporter.
set hold_type='T', target=
where id=313288;
Update on hold_request_record (cost=0.43..4.45 rows=1 width=10) (actual time=13653.
-> Index Scan using reporter_
Index Cond: (id = 313288)
Planning time: 0.904 ms
Execution time: 13653.535 ms
(5 rows)
13 seconds to update a row in that table!
I don't really know what the solution is.
Changed in sipserver: | |
status: | New → Invalid |
I just realized that I am on SIPServer.... Doh!