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

SPIKE - investigate performance of hiera storage/querying

    Details

    • Type: Improvement
    • Status: Ready for Merge
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Template:
    • Acceptance Criteria:
      Hide

      Recommendations for

      • The proper indices for the catalog_inputs for optimal query/gc/storage size efficiency
      • The most efficient method of storing a new set of hiera inputs
      Show
      Recommendations for The proper indices for the catalog_inputs for optimal query/gc/storage size efficiency The most efficient method of storing a new set of hiera inputs
    • QA Risk Assessment:
      Needs Assessment

      Description

      The current storage strategy (delete all and then store the new) is likely not efficient enough for large production deployments. The same is true for the indices on the catalog_inputs table.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                rob.browning Rob Browning
                Reporter:
                austin.blatt Austin Blatt
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Zendesk Support