authority.authority_linking needs more indexes

Bug #2012517 reported by Galen Charlton
36
This bug affects 8 people
Affects Status Importance Assigned to Milestone
Evergreen
New
Medium
Unassigned

Bug Description

The authority.authority_linking table does not have any indexes on the source and target columns. While that table will typically have only a few tens of thousands of rows at most, adding indexes on those columns would provide a minor speedup to authority ingest and linking operations - and a major speed increase to reports that involve that table.

Galen Charlton (gmc)
tags: added: database performance
Changed in evergreen:
importance: Undecided → Medium
Revision history for this message
Jason Boyer (jboyer) wrote :

We've also seen in the past (action_trigger.event) that indexes are very helpful for maintaining referential integrity should the PK tables grow large.

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.