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?
@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.
not worth the effort required to fix it