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

SPIKE: investigate improving reports / resource events table

    Details

    • Type: Story
    • Status: Accepted
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: PuppetDB
    • Labels:
      None
    • Template:
    • Team:
      PuppetDB
    • QA Risk Assessment:
      Needs Assessment

      Description

      PE writes a "resources" column in the reports table that contains all resources (and events) during a puppet run, including changed and unchanged resources.

      In FOSS, this column is left empty.

      In both environments, the resource_events table contains a normalized version of the events from the reports.

      Investigate if these can be combined. This would reclaim storage space.

      Investigate if table partitioning can be used on the reports table.

        Attachments

          Activity

            People

            • Assignee:
              robert.roland Robert Roland
              Reporter:
              robert.roland Robert Roland
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:

                Zendesk Support