Closed Bug 483245 Opened 15 years ago Closed 15 years ago

drop bad indexes and create correct index in PROD Socorro DB

Categories

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Product:
Infrastructure & Operations Graveyard
Component:
WebOps: Other
Platform:
All
Other
Type:
task
Priority:
Not set
Severity:
major

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: ozten, Assigned: aravind)

Details

Please run the following queries in production Socorro postgres db. If there is any output, please paste in bug.

drop index topcrashurlfacts_day_key;
drop index topcrashurlfacts_productdims_key;
drop index topcrashurlfacts_signaturedims_key;
drop index topcrashurlfacts_urldims_key;

create index topcrashurlfacts_date_prod_url_sig on topcrashurlfacts (day, productdims_id, urldims_id, signaturedims_id);
This looks ok to me -- but we should probably wait until we get updated stats after lunch.
breakpad=# drop index topcrashurlfacts_day_key;
DROP INDEX
breakpad=# drop index topcrashurlfacts_productdims_key;
DROP INDEX
breakpad=# drop index topcrashurlfacts_signaturedims_key;
DROP INDEX
breakpad=# drop index topcrashurlfacts_urldims_key;
DROP INDEX
breakpad=# 
breakpad=# create index topcrashurlfacts_date_prod_url_sig on topcrashurlfacts (day,
productdims_id, urldims_id, signaturedims_id);
CREATE INDEX
breakpad=#
Assignee: server-ops → aravind
Status: NEW → RESOLVED
Closed: 15 years ago
Resolution: --- → FIXED
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
Product: Infrastructure & Operations → Infrastructure & Operations Graveyard
You need to log in before you can comment on or make changes to this bug.