Closed Bug 1178038 Opened 9 years ago Closed 9 years ago

Add an index to the signature column in the the job_eta table

Categories

(Tree Management :: Treeherder: Data Ingestion, defect)

Product:
Tree Management
Component:
Treeherder: Data Ingestion
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED DUPLICATE of bug 1196764

People

(Reporter: mdoglio, Unassigned)

Details

Every time we store a job we do a full scan on the job_eta table to retrieve its eta. The table has a significant size, so we end up scanning more than 1.7M rows. We should add an index to the signature column to avoid that.
Given the size of some of the current tables (eg 2.8 million rows for the mozilla-inbound one), I think trying to add an index now is going to need a failover. I'm hoping bug 1181572 will take a little bit of pressure off, after which I think we're best waiting for the new implementation in bug 1196764.
Status: NEW → RESOLVED
Closed: 9 years ago
Resolution: --- → DUPLICATE
You need to log in before you can comment on or make changes to this bug.