Uploaded image for project: 'PuppetDB'
  1. PuppetDB
  2. PDB-1224

Move fact path reference from the fact_values table to the facts table

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: PDB 2.3.1
    • Component/s: None
    • Labels:
      None
    • Template:
    • Story Points:
      1
    • Sprint:
      PuppetDB 2015-02-25, PuppetDB 2015-03-11, PuppetDB 2015-03-25, PuppetDB 2015-04-08

      Description

      Although our current table structure is more efficient from a space perspective, it's more costly to query. We should create a migration that drops the fact path id from the fact_values table and instead have the facts table point at both the fact value and the fact path along with the factset. A quick first pass at this migration will allow the fact diffing logic to be updated in parallel. Care needs to be taken that we do this migration efficiently and quickly as it will be adding a new (populated, non-null) column on a table that is potentially very large.


      QA Risk Assessment

      Probability Low (re-arranging internals)
      Impact Medium (limited, not catastrophic)
      Risk Level Low
      Test Level Unit

        Attachments

          Issue Links

            Activity

              jsd-sla-details-panel

                People

                • Assignee:
                  rob.browning Rob Browning
                  Reporter:
                  ryan.senior Ryan Senior
                  QA Contact:
                  Kurt Wall
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Zendesk Support