Separate views from mat views in the docs

RESOLVED WONTFIX

Status

Socorro
General
RESOLVED WONTFIX
6 years ago
11 months ago

People

(Reporter: selenamarie, Unassigned, Mentored)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

Separate views from mat views in the docs
OS: Mac OS X → All
Hardware: x86 → All
Whiteboard: [mentor=selena@mozilla.com]

Updated

4 years ago
Mentor: sdeckelmann
Whiteboard: [mentor=selena@mozilla.com]

Comment 1

4 years ago
Can I get a more detailed description for this, so that I can farm it out to the community?
Flags: needinfo?(sdeckelmann)
We would like to document the differences between "materialized views" - in our case, actual tables that are written to, and the "views" which are Postgres VIEWs which query underlying tables on-demand.  Currently these are documented as though they are the same, leading to performance issues when the wrong tables are used. 

To find this information, a person could look into socorro/external/postgresql/raw_sql/views to find the VIEW information and socorro/external/postgresql/models.py to locate "materialized views" - which are primarily tables that serve report data to the middleware. The targeted tables are mentioned in this diagram: http://socorro.readthedocs.org/en/latest/databaseschema.html#materialized-view-reporting

Ideally someone would consult with the #breakpad channel as they embarked on this.
Flags: needinfo?(sdeckelmann)

Comment 3

11 months ago
per 1361394, we intend to delete or rewrite
Status: NEW → RESOLVED
Last Resolved: 11 months ago
Resolution: --- → WONTFIX
You need to log in before you can comment on or make changes to this bug.