user merge very slow to process on large datasets

Bug #1374551 reported by Chris Sharp on 2014-09-26
20
This bug affects 4 people
Affects Status Importance Assigned to Milestone
Evergreen
High
Unassigned
2.5
Undecided
Unassigned
2.6
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

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
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  Edit
Everyone can see this information.

Other bug subscribers