Details

    • Type: Epic
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: PDB 4.4.0
    • Component/s: None
    • Labels:
      None
    • Epic Name:
      PDB Package Inventory
    • Template:
    • Team/s:
      Systems Engineering
    • QA Risk Assessment:
      Needs Assessment

      Description

      Improve Package Inspector storage performance. Package data is stored in separate package inventory tables. This data is exposed to the user (or the console) via the inventory endpoint. Storing this data relationally requires less disk space than storing them as facts. This also allows us to use the techniques (like hashing) and tools (various indexes) PostgreSQL has available to improve the performance of the queries. By separating packages from facts we are not conflating two conceptually different things.
      In depth discussion of this proposal https://docs.google.com/document/d/1LRuONlsPcoE4Z5RMAXc65kkwPUs1lPx7CbA9VMuKFes/edit#.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                ryan.senior Ryan Senior
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Zendesk Support