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

Partition the reports table

    XMLWordPrintable

Details

    • Story
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • None
    • PDB 6.10.0
    • PuppetDB
    • None
    • Enhancement
    • Partition the reports table by day for better query and garbage collection performance
    • Needs Assessment

    Description

      The report table needs to be partitioned by day, like the resource_events table, to optimize storage and make it easier to deal with additional data being added from Bolt.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. PDB-4675 Deadlock when creating/inserting into a new report partition

          • Normal - Regular issue, some loss of functionality under specific circumstances.
          • Resolved

          Activity

            People

              austin.blatt Austin Blatt
              robert.roland Robert Roland
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Zendesk Support