Will Kahn-Greene [:willkg] ET needinfo? me Assignee
	Description • 6 years ago

Socorro has Postgres views in:

socorro/external/postgres/raw_sql/views/

Some/many/all of these views are no longer used and we should remove them.

This bug covers figuring out which are used and which aren't and then deleting the ones that aren't.

	Will Kahn-Greene [:willkg] ET needinfo? me Assignee
	Comment 1 • 6 years ago

Making this a P1 and grabbing this to do soon. This should be a 1-day project and cleaning up views behooves us greatly because it makes other cleanup work easier.

	Will Kahn-Greene [:willkg] ET needinfo? me Assignee
	Comment 2 • 6 years ago

I went through all the views and seems like none of them are being used.

I'm going to remove them all.

	[github robot]
	Comment 4 • 6 years ago

Commits pushed to master at https://github.com/mozilla-services/socorro

https://github.com/mozilla-services/socorro/commit/65dea66b3d882adb58f1a09ec0d4cfedeff52b40
fixes bug 1424370 - remove all the postgres views

None of these views are used, so I removed all the views and the
infrastructure for loading views.

https://github.com/mozilla-services/socorro/commit/884c826028bfcfddbb2ed1b9f544c0b8952d5c56
Merge pull request #4261 from willkg/1424370-views

fixes bug 1424370 - remove all the postgres views