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

SPIKE: investigate improving reports / resource events table

    XMLWordPrintable

    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