serial.record_entry needs an index on the record column

Bug #800706 reported by Jason Etheridge
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
Fix Released
Low
Unassigned
2.7
Fix Released
Low
Unassigned
2.8
Fix Released
Low
Unassigned

Bug Description

Particularly when merging bib records, a sequential scan is made against that table.

Tags: pullrequest
Changed in evergreen:
status: New → Incomplete
Revision history for this message
Jason Stephenson (jstephenson) wrote :

It looks like this still needs to be done. If no one else beats me to it, I'll make a branch to take care of it shortly.

Changed in evergreen:
status: Incomplete → Confirmed
Galen Charlton (gmc)
tags: added: bitesize
Galen Charlton (gmc)
Changed in evergreen:
assignee: nobody → Galen Charlton (gmc)
Revision history for this message
Galen Charlton (gmc) wrote :

A patch is available at the tip of the user/gmcharlt/lp800706_index_sre_record branch in the Evergreen repository:

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/gmcharlt/lp800706_index_sre_record

tags: added: pullrequest
removed: bitesize
Changed in evergreen:
assignee: Galen Charlton (gmc) → nobody
importance: Undecided → Low
Revision history for this message
Galen Charlton (gmc) wrote :

I've pushed a regression test to that branch as well.

Changed in evergreen:
assignee: nobody → Jason Stephenson (jstephenson)
milestone: none → 2.next
Changed in evergreen:
status: Confirmed → Fix Committed
Changed in evergreen:
assignee: Jason Stephenson (jstephenson) → nobody
Changed in evergreen:
milestone: 2.next → 2.9-alpha
Changed in evergreen:
milestone: 2.9-alpha → 2.9-beta
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.