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

SPIKE - investigate performance of hiera storage/querying

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • 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
    • Team:
      PuppetDB
    • Release Notes:
      Not Needed
    • 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:
                Resolved:

                  Zendesk Support