724884 - Drop report_id, replace with UUID everywhere

Status: RESOLVED WONTFIX

(Socorro :: Database, task)

Description

[[:jberkus] Josh Berkus]

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?

Comment 1

[K Lars Lohn [:lars] [:klohn]]

@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.

Comment 2

[Lonnen :lonnen]

not worth the effort required to fix it