Evergreen

authority.simple_heading needs an index on the record column

Bug #1447168 reported by Galen Charlton
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Evergreen
Fix Released
Medium
Unassigned
Evergreen 2.9-beta
2.7
Fix Released
Undecided
Unassigned
Evergreen 2.7.6
2.8
Fix Released
Undecided
Unassigned
Evergreen 2.8.2

Bug Description

The table authority.simple_heading lacks an index on the record column but needs one -- otherwise, reingesting an authority record in a database that has a lot of them causes a sequential scan on authority.simple_heading to when removing old ash rows.

Evergreen master

Tags: pullrequest
Revision history for this message
Galen Charlton (gmc) wrote :

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

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

tags: added: pullrequest
Dan Wells (dbw2)
Changed in evergreen:
assignee: nobody → Dan Wells (dbw2)
Revision history for this message
Dan Wells (dbw2) wrote :

Simple and effective fix. Pushed to master through 2_7. Thanks, Galen!

Changed in evergreen:
milestone: none → 2.9-alpha
assignee: Dan Wells (dbw2) → nobody
status: New → Fix Committed
Jason Stephenson (jstephenson)
Changed in evergreen:
milestone: 2.9-alpha → 2.9-beta
Evergreen Bug Maintenance (bugmaster)
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.
Subscribing...

Other bug subscribers

Remote bug watches

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