Drop report_id, replace with UUID everywhere

RESOLVED WONTFIX

Status

Socorro
Database
RESOLVED WONTFIX
6 years ago
a year ago

People

(Reporter: jberkus, Unassigned)

Tracking

unspecified
Future
x86
Mac OS X

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

6 years ago
The way it is now:

For no good reason, the Postgres database takes the UUID, but adds a second, unrelated SERIAL key to each report called report_id.  This is then used for joins to the extensions and plugin_reports tables.

report_id is completely unnecessary, adds storage and extra JOIN steps we don't need.  UUID is already defined as unique.

As such, I want to remove the report_id from the database entirely, and replace it with using the UUID everywhere.  AFAIK, the only affected tables would be reports, extensions, and plugins_reports.

Assigning to lars to query for the impact on the processors.  Lars?
Target Milestone: 2.5 → 2.5.3
Target Milestone: 3 → 5
Target Milestone: 5 → 9
Target Milestone: 9 → Future
@selenamarie, reassigning this PG bug to you.  Feel free do close as WONTFIX if you do not thing it a valid or worthwhile issue to resolve.
Assignee: lars → sdeckelmann
Assignee: sdeckelmann → nobody

Comment 2

a year ago
not worth the effort required to fix it
Status: NEW → RESOLVED
Last Resolved: a year ago
Resolution: --- → WONTFIX
You need to log in before you can comment on or make changes to this bug.