user merge very slow to process on large datasets

Bug #1374551 reported by Chris Sharp
20
This bug affects 4 people
Affects Status Importance Assigned to Milestone
Evergreen
Fix Released
High
Unassigned
2.5
Fix Released
Undecided
Unassigned
2.6
Fix Released
Undecided
Unassigned

Bug Description

We have seen long (20 to 30 second) delays when performing patron merges either via the staff client or directly via the actor.usr_merge() function. Debugging reveals a need for an index on money.billing(voider).

Evergreen 2.5.1
OpenSRF 2.2
PostgreSQL 9.3
Ubuntu 14.04 LTS

Tags: pullrequest
Revision history for this message
Chris Sharp (chrissharp123) wrote :
Changed in evergreen:
assignee: nobody → Chris Sharp (chrissharp123)
importance: Undecided → High
status: New → In Progress
milestone: none → 2.7.1
tags: added: pullrequest
Revision history for this message
Ben Shum (bshum) wrote :

Picked to master and backported to rel_2_7, rel_2_6, and rel_2_5. Thanks Chris!

Changed in evergreen:
status: In Progress → Fix Committed
assignee: Chris Sharp (chrissharp123) → nobody
Changed in evergreen:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.